>>Regex : http://msdn.microsoft.com/en-us/library/system.text.regularexpressions.regex.aspx
>
>Thanks

(1) Probably instead of Mid() + compare you can also directly compare parts of a string

http://msdn.microsoft.com/en-us/library/1e058ek8.aspx

You pass two strings, offset in string one, offset in string two, length to compare, and ignoreCase


(2)
If you post an example of a representative string in sql, including remarks and keyword list, color needed (eg green for comments, blue for keywords) - I can have a go it it in the weekend with regular expressions - would be fun - no success promised -