>>>Right, thanks. Still need to remove ; if we use the original code, though, and want to be able to run this select in command window first.
>>
>>Naomi,
>>While you need to remove ;
>>Just write your example without ;
>
>Because I want to be able to copy the select into the command window and run it.
You could run it from a temporary PRG you create.
or run it in Command window, then remove [;] :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.