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...
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
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
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
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
5 matches
Mail list logo