trims berat mas Arief .... --- In [email protected], "Arief Wijana" <[EMAIL PROTECTED]> wrote: > > 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] >
