You're welcome.

>Hi Sergey:
>
>I didn't know that TRANSFORM could be used quite like that. Thanks!
>
>To accommodate the possibility of a .NULL. value it seems that you would need to code:
>
>

lcCharacterVariable = TRANSFORM(NVL(lxVariableOfUnknownType,''))

>
>Yossi
>
>>Check TRANSFORM() function.

lcCharacterVariable = TRANSFORM(lxVariableOfUnknownType)