Posted by bmeyynospamnospam on 06/15/05 01:05

Thanks Stu,
Can I just put the case statement into the grid in MS SQL?
I can't seem to get th egrid to work, or should I not be using the
grid.

Brad

"Stu" <stuart.ainsworth@gmail.com> wrote:

>In MS Access, write a qury that uses an IIF command, and then flip to
>the SQL view from the dropdown. This should show you the SQL syntax
>for entering a command; CASE is similar.
>
>SELECT field1, field2=CASE WHEN field1='NY' THEN 1 ELSE 0 END
>FROM table
>
>
>Hope that helps,
>Stu

[Back to original message]