Hi
how do i find the phone numbers from a string in sqlserver.
i have a table have columns id,Content
id is auto generated and content column contains different CV's content and i need to find all the phone numbers and email from this CV content.
in C# i have done the same using regexp but not able to do in sqlserver..is it possible to use regexp in sqlserver..
Ex: Input : Content = 'santosh kumar this saaksa santosh@gmail.com 9902007445 testing tet 9765555512 fdfd 43434343 '
output should be :
Phone Numbers: 9902007445 ,9765555512
Email: santosh.mca15@gmail.com
Thanks
Santosh