>>Thanks Naomi. I knew you could use CRLF but I was wondering if there was a more direct way.
>
>Don........
>
>Be aware that this is only an approximation. The difference is that the line would be compiled and executed as if it were a procedure. Any variables declared inside the procedure would disappear when it ends. In your case it means that unless X and Y already existed, they would not still not exist when this line is executed.
>
>SET NIT_PICK ON
>Pretty sure the CHR(10) piece is not needed
>SET NIT_PICK OFF
Yes, that's what I was also thinking but got lazy to write. It's obviously not a solution for the example shown.
If it's not broken, fix it until it is.
My Blog