Tina,
Can you post a sample of a SELECT statement you're having trouble with? If you do, someone will probably be able to identify the problem.
>I just migrated an app from 3.0 to 6.0, and the one problem I'm having is with Select-SQL statements that use UNION.
>
>When the statement gets to a Group by line, it fails.
>
>Does UNION no longer work? I see that it is no longer in the documentation!
>
>Thanks,
>
>Tina Robichaux
>Interland, Inc