On Wed, Jun 4, 2008 at 1:59 PM, Mike yearwood <[EMAIL PROTECTED]> wrote: > That's cool getting the && out. Could you not do everything from the > && to the end of the line? Since you are calling regexp already, can > you remove the chr(10), chr(9), chr(13), leading spaces and ; all with > a single RegExp?
Good thinking: I'll have to look at it later. Thanks also to Richard: this is Oracle, not SQL Server, but there might be equivalent functionality. _______________________________________________ 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/[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.

