>
> 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 understands this nowadays.
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
