Check for alpha numeric characters

pk400i · February 10, 2023, 1:26pm

We have a field called id_number which is a varchar 50 null.
Most of the id's are nuneric but sometimes we put a holding value until the id_number is ready from payroll.
So we will put 'IT Temp' or like that.
I would like to report on which staff have this type of 'IT Temp' that is there is at least one alpha character in the field.

robert_volk · February 10, 2023, 1:54pm

SELECT id_number FROM myTable WHERE id_number LIKE '%[^0-9]%'

harishgg1 · February 11, 2023, 7:00am

another way to do this
performance
execution plan
network round trips
may be different and helpful

JeffModen · February 12, 2023, 9:57pm

@harishgg1
You've got the code right there... why not post it so that your good example is readily consumable instead of a graphic? We don't like it when people asking questions do it.