RegExp - Commonly Used Expressions

http://www.mssqltips.com/tip.asp?tip=2297&home

Common Regular Expressions:

• Internet Email:                   \w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*
• Internet URL:                     http(s)?://([\w-]+\.)+[\w-]+(/[\w- ./?%&=]*)?
• US Phone Number:             ((\(\d{3}\) ?)|(\d{3}-))?\d{3}-\d{4}
• US Social Security Number: \d{3}-\d{2}-\d{4}
• US ZIP Code:                     \d{5}(-\d{4})?
• URI:                                 \b(\S+)://([^:]+)(?::(\S+))?\b
• Date YYYYMMDD:               ^(19|20)\d\d[- /.]?(0[1-9]|1[012])[- /.]?(0[1-9]|[12][0-9]|3[01])