View Single Post
  #1 (permalink)  
Old June 24th, 2003, 09:30 PM
cej2583 cej2583 is offline
Authorized User
Join Date: Jun 2003
Location: Brentwood, TN, USA.
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default IF Statement in the SQL Design View

I'm converting queries from Access 2000 to SQL views. I need to covert the following expression from Access 2000 to SQL.

Volume: IIf([Divisor]=0,0,[SumOfUnitsMA]/[Divisor])

Volume is a field alias and [Divisor],[SumOfUnitsMA] are fields within the same view/query.

Is there a way to express this in SQL Server Enterprise Manager View Deisgn (in the COLUMN column).

Please email me at if you have any questions.

Thanks for any assistance !!!

Reply With Quote