On Wed, 7 May 2008 12:41:01 -0700 (PDT), Lamb Joseph wrote: >I will have to break apart the SQL statement with a regex and store it that >way. > >Thanks for the input.
More input: take a look at Ovid's article "Lexing Your Data" on perl.com, at http://www.perl.com/pub/a/2006/01/05/parsing.html which discusses using a tokenizer (lexer) to pull tokens, such as table names, out of SQL statements. -- Bart.