converting Access 2000 views to Sql views
I'm converting queries from Access 2000 to SQL views. I need to covert the following expression from Access 2000 to SQL.
Volume: IIf([OriginalOrderNo] = 0, [ acsuorders_summary] ! [order_no], [OriginalOrderNo])as ordernum.
is there any chance i can use the same in sql plz help.