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 understands this nowadays.
Jochem
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- iif in MSSQL Richard Meredith-Hardy
- Re: iif in MSSQL Massimo Foti
- Re: iif in MSSQL Jochem van Dieten
- Re: iif in MSSQL Qasim Rasheed
- Re: iif in MSSQL Richard Meredith-Hardy