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