Community

Yes, that works except for the case where a non-comment line has spaces before the code. Try this (replace <space> and <tab>) and note that it does not find the lines in red. Thanks for all the help

--Test SQL--
select b.column_name, a.column_name from table1 a
join table2 b
on b.column_id = a ...

I only want the Search to find the lines listed in the SQL test which are in green. I have put <space> and <tab> markers in the text to mean that they are spaces or tabs as this forum seems to remove leading spaces in lines. Thanks for all your help


--Test SQL--
select b.column_name, a.column ...

Thanks, that works but not for lines which have "--" as the first non-blank string i.e I want to ignore lines which have "--" as the first non-blank string on the line. Thanks

I wish to search for all lines of files which have a certain string say "ABCD" but want to ignore lines which have the FIRST non-space string as "--" (i.e the comment specifier). Can someone please say what the Regular Expression for this is.

Thankls