sql server - Wildcard characters sql only alphabet characters -


i need create rule alphabet characters

i used following wildcard character sequences didn't work !

like '[a-za-z]'

like 'a-z'

like 'a-za-z'

double negative like

where   somecol not '%[^a-z]%' 

ignoring first not, means "match character not in range z".

then, reverse using first not means "don't match character not in range z"

edit, after comment

like '%[a-z]%' means "find single character between a-z. 111s222 matched example because s matches in like.


Comments

Popular posts from this blog

php - How to build a web site which gives a sub-domain dynamically to every registered user? -

Delphi Wmi Query on a Remote Machine -