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.

Hi there is no equivelent IIF function in SQL. You need to either use:

If
  Begin
      ..do something
  End
Else
   Begin
      ..do someting
   End

or Use a Case When statement:

Case <var or value to check>
   When <exp> Then <exp>
Else
   else_result_expression
End

The Sql Books Online will be very helpful to you.