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)
--sb--