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

Thanks Stu,
My experimentation has found exactly that.
The grid will not support case statements, so you have to write them
directly in the sql window.
I was able to get my statements to work pretty well once I figured out
how the landscape was different than access.

Access does hold your hand a bit more and it's going to take some time
to get used to writing from scratch.

Thanks again.
Brad


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

>If you're talking about the grid in Enterprise Manager, try to wean
>yourself off of that as quickly as you can. It limits your flexibility
>in writing clean SQL statements. I don't use it, and so I'm not sure
>how to write a CASE statement in it, but I belive you can write it
>directly in it.
>
>You may want to to try writing a simple select statement using the
>grid, and then adding the case statement to the SQL statement, and then
>flip back to the grid to see how it gets interpreted.
>
>Stu

[Back to original message]