Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sanjay5219
Posting Yak Master
240 Posts |
 Posted - 2014-08-29 : 09:07:19
|
| Hi,I have a situation where I have text in one column and now i have to search wheather any phone no is their or mail.We have got that phone will start from Mobile or Mand e Mail Id will start from mail/eMailPlease suggest |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-08-29 : 09:51:46
|
| lookup the PATINDEX function:http://msdn.microsoft.com/en-ca/library/ms188395.aspx |
 |
|
|
|
|
|
Text Reading