LYCOS RETRIEVER 
Regular Expression: Strings
built 635 days ago
Regular Expressions can be very useful to the Database programmer, particularly for data validation, data feeds and data transformations. A lot of the time, tools such as grep and awk or Funduc's S&R will be the most suitable way of using regular expressions, but just occasionally, it is handy to be able to use them in TSQL as we'll try to show.
Source:
The third part of a regular expression is the modifier. It is used to specify how may times you expect to see the previous character set. The special character "*" matches zero or more copies. That is, the regular expression "0*" matches zero or more zeros, while the expression "[0-9]*" matches zero or more numbers.
Source:
This module provides regular expression matching operations similar to those found in Perl. Regular expression pattern strings may not contain null bytes, but can specify the null byte using the \number notation. Both patterns and strings to be searched can be Unicode strings as well as 8-bit strings. The
Source:
This is the software for creating regular expression and testing it. Can write regular expressions, even if you do not know about the details of regular expression. You can buy the Source Code (C#2005, VB2005, C#. NET, VB.NET) of this software. Version 1.41 includes unspecified updates.
Source:
When the regular expression used with the string method match has the global (g) flag an array of matches is returned. If the global flag is not present, the return is the same as RegExp method exec: array element 0 contains the complete matched string and subsequent elements contain subsets ($1, $2, etc.). In either case, no match returns null.
Source:
Regular expressions provide a powerful, flexible, and efficient method for processing text. The extensive pattern-matching notation of regular expressions allows you to quickly parse large amounts of text to find specific character patterns; to extract, edit, replace, or delete text substrings; or to add the extracted strings to a collection in order to generate a report. For many applications that deal with strings (such as HTML processing, log file parsing, and HTTP header parsing), regular expressions are an indispensable tool.
Source:
MORE ABOUT
Strings