Coba pake fungsi select (case b when 0 then 'Enol' else 'satu' end) as Expr1 from table1
Semoga Membantu arief ----- Original Message ----- From: simbok_cahyo To: [email protected] Sent: Tuesday, February 13, 2007 12:20 PM Subject: [indoprog-vb] Query Access VS T-SQL dear teman2 vbers, mo minta tolong lagi. saya punya query access sbb: SELECT Table1.a, Table1.b, IIf([Table1]![b]=0,'ENOL','SATU') AS Expr1 FROM Table1; databasenya saya ganti SQL Server, trus query di atas harus saya ganti gimana ya? soalnya di SQL Server ga ada fungsi IIF. trims sebelumnya. salam, cahyo [Non-text portions of this message have been removed]
