iif in MSSQL

2004-09-20 Thread Richard Meredith-Hardy
dear all is there a way of doing the following in a query to MSSQL like you can to access? SELECT field1, field2, iif(field1 = field2,'same','different') AS mynote FROM mytable WHERE etc I appreciate it could be done in a SP or by analysing the output but in this case it is easier not to...

Re: iif in MSSQL

2004-09-20 Thread Massimo Foti
is there a way of doing the following in a query to MSSQL like you can to access? SELECT field1, field2, iif(field1 = field2,'same','different') AS mynote FROM mytable WHERE etc I appreciate it could be done in a SP or by analysing the output but in this case it is easier not to... Check

Re: iif in MSSQL

2004-09-20 Thread Jochem van Dieten
Richard Meredith-Hardy wrote: is there a way of doing the following in a query to MSSQL like you can to access? SELECT field1, field2, iif(field1 = field2,'same','different') AS mynote FROM mytable WHERE etc Look up the CASE .. WHEN .. THEN blabla statement. Maybe even Access

Re: iif in MSSQL

2004-09-20 Thread Qasim Rasheed
http://www.extremeexperts.com/sql/faq/IIForDecode.aspx - Original Message - From: Richard Meredith-Hardy [EMAIL PROTECTED] Date: Mon, 20 Sep 2004 10:36:13 +0100 Subject: iif in MSSQL To: CF-Talk [EMAIL PROTECTED] dear all is there a way of doing the following in a query to MSSQL like

Re: iif in MSSQL

2004-09-20 Thread Richard Meredith-Hardy
Perfect.Thankyou! -- Regards; Richard Meredith-Hardy - r[dot]mh[at]flymicro[dot]com Tel: + 44 (0)1462 834776 FAX: + 44 (0)1462 732668 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations