>>The important thing to remember is to always specify a lenght for the variable length expression used in SQL-select as otherwise SQL decides the final length based on the first expression it processes.
>
>I didn't know it. Thank you.


And remember that "the first expression it processes" might be completely random to you. So it might run fine in testing environment and on site it's a complete desaster.

(^_^)