Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jon McGhee IsAlphaNumeric RE: IsAlphaNumeric
nigel.
SSChampion
Points: 11636
More actions
December 1, 2011 at 8:41 am
#1415319
Aha! I found where you hid it eventually 😀
There's no need for a loop! What's wrong with PATINDEX for this sort of thing?
SELECT PATINDEX('%[^A-Za-z0-9 ]%', 'ABC 123')
SELECT PATINDEX('%[^A-Za-z0-9 ]%', 'ABC*123')
NigelHow to post questions