I am currently working on a SQL validator for ASP and am wanting to remove the comments from the SQL before I run it through SQLDMO. As you know there are two styles for SQL comments; inline ("--") and block("/**/"). Anyway I have created a Regular Expression that removes the inline comments, and I thought that I had one for block style, but after some testing I reallized I was wrong. This is the regular expression I used: <BR>(/*)((.&#124
){0,})(*/)<BR>It does fine if there is only one comment block in the SQL, but if there are multiple blocks such as:<BR>/*This is a Comment*/ <BR>select blah from table_blah<BR>/*This is also a comment*/<BR><BR>it matches the whole string not just the commented sections. Does anyone know a Regular Expression that would just match the commented sections (I&#039;m replacing them with empty strings.) Any help would be appreciated.<BR><BR>Thanks,<BR><BR>Matt