|
|
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
Navigation:
[Reply to this message]
|