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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to find alphanumeric values in name

Author  Topic 

sree25
Starting Member

5 Posts

Posted - 2015-03-26 : 15:28:27
i have a column called firstname ..in that it stores value like this


john smith
andrew jr
jim sr
andrew bar
tina *^
don $%

I need to retreive all those rows where name consists of non alphabets...for example 5 and 6 has non alphabets..
i am using PATINDEX('%[^a-z]%',Firstname) function but if it finds space between names it is considering as error..I would like to find only non alphabets in name ..space is fine..is there any function to find out?

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-03-26 : 15:38:20
how about:


replace(firstname, ' ', '') not like '%[^a-z]%'
Go to Top of Page

sree25
Starting Member

5 Posts

Posted - 2015-03-26 : 17:24:01
Yep it worked ..thanks
Go to Top of Page
   

- Advertisement -