>>>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.
>
>(^_^)
Yes, it is possible.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham