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... t

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..

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 u

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 qu

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] [Donation