Thanks, to everyone who replied. My statement will always have a Select and FROM so I went with the <cfset newString = rereplacenocase(theQuery,"^.*?SELECT\s(.*?)\sFROM\s.*$","\1")> which works great.

Thanks again!
- Charles
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to