> 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 the docs for "CASE".
The T-SQL equivalent should be something like:
SELECT field1, field2,
(CASE
WHEN (field1 = field2)
THEN 'same'
ELSE 'different'
END)
AS mynote
FROM mytable
Maybe it's not worth creating a dedicated SP, but you could still but it
inside a view and embed just a minum amount of SQL inside your CFML. You
would end up with something like:
SELECT *
FROM my View
WHERE etc
----------------------------
Massimo Foti
http://www.massimocorner.com
----------------------------
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]