This works fine on my system. At first I wasn't sure about the 0 length string in the CAST but it works fine. So you must be missing a paren in there somewhere...
SELECT rktemp.*, CAST([] AS memo) test FROM c:\rfc\rktemp INTO CURSOR test -- rk -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Kurt Wendt Sent: Wednesday, April 04, 2012 5:54 PM To: [email protected] Subject: RE: Memo Fields in SQL SELECTS... I hate to be a PITA - but, that did not work! I got an error: Function name is missing ). _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD0441D52B6DECA@ACKBWDDQH1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

