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 CEricJones16@msn.com if you have any questions.

Thanks for any assistance !!!

CEJ
__________________
CEJ
Reply With Quote