Hey Sergey,

I'm just going to say THANKS for all the solutions you've given this and my other threads the past week. If they still rewarded points you would be the front runner as usual.

>Try

TRANSFORM(MyField)

>
>>In the following the type of MyTableField is character. MyCursor.MyField could be character, an integer, a logical, etc. Without an involved IIF statement or CASE statements, is there a way to convert any type to a string without knowing what it is beforehand?
>>
>>
>>

>>LPARAMATERS MyCursor
>>
>>MyVar = ''
>>
>>SELECT MyCursor
>>
>>SCAN
>>   MyVar = MyVar + ALLTRIM(MyField) + '|'
>>ENDSCAN
>>
>>INSERT INTO MyTable (MyTableField) VALUES (MyVar)
>>