These are my examples:



SELECT *

INTO #TEMP

FROM TABLE



SELECT * INTO #TEMP FROM TABLE



I would like some help creating a RegEx pattern to find the word INTO followed by a space then a pound sign (#) then a wildcard for the temp table name then another space.



Thanks

Thanks guys! This is awesome information... I've submitted the PO for the RegExBuddy.



The expression wont find the INTO #TEMP on its own line... it'll only find the one thats on the same line. What do I need to change?