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]