Check for alpha numeric characters

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.

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


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

1 Like

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. :stuck_out_tongue_closed_eyes: