There is nothing in Help about a 255 limit when the pretext expression is numeric ...
Paul Newton > I'd offer a quick comment that the semicolons are not necessary if you > use the PRETEXT 15 clause, plus you're that much more ready and not > having to rewrite this code if you send it against a remote RDBMS server. > > As long as your final SQL statement is not longer than 255 characters, then the PRETEXT 15 is OK. Fred --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.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.

