>>((http[s]?|ftp)://[\w/.()-]+[\w/.(-]) >>>>
>>http://msdn.microsoft.com/en-us/library/aa172799(SQL.80).aspx >> >>and >>http://msdn.microsoft.com/en-us/library/aa172799SQL.80.aspx >> >>in >> >>(http://msdn.microsoft.com/en-us/library/aa172799SQL.80.aspx) >>>
(((http[s]?|ftp)://)|(www\.))[\w/.()-]+[\w/.(-]if you need two patterns, you can make one