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 |
|
sree25
Starting Member
5 Posts |
 Posted - 2015-03-26 : 15:28:27
|
| i have a column called firstname ..in that it stores value like thisjohn smithandrew jrjim srandrew bartina *^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]%' |
 |
|
|
sree25
Starting Member
5 Posts |
Posted - 2015-03-26 : 17:24:01
|
| Yep it worked ..thanks |
|
|
|
|
|
|
How to find alphanumeric values in name