>>>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 -
Check Problem with database named database.mdf Thread #1484696 Message #1484696