The problem lies in the use of << >> delimiters that are replaced with the value resulted from the contained expressions only in text/endtext construct or using the TEXTMERGE() function.
One solution is that from Rob Anderson. My advise is to continue to use text/endtext construct to build the single pieces of the sql query to maintain readability. -- Gianni _______________________________________________ Post Messages to: ProFox@leafe.com 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/[EMAIL PROTECTED] ** 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.