>>I have having a problem converting my SQL data into a CHR(254) field instead of a MEMO field when using SQLEXEC. I know how to do it using remote views, but can anyone tell me how to put my data into a CHR with SQLEXEC?
>>
>>Thanks in Advance...
>
>If the contents of the fields is less them 254 chars, you could try:
>

>TEXT TO lcSQL NOSHOW PRETEXT 15
>     SELECT CAST(MyField as Varchar(254)) AS MyField
>             ....
>     FROM .....
>ENDTEXT
>SQLEXEX(lnSql ,lcSQL,[MyCursor])
>

Borislav,
Thanks so much. That did the trick.
freddie