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...
thanks
--
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 and Support]
