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)