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