Check for alphas and numerics in

Question

I'm using the dbvisualizer SQL statement and am trying to search a field for whether it has letters and numbers, or just one or the other. Is this possible to do in a simple manner? Currently I'm just checking each one individually like so:

case when card_address like '%0%'
       or card_address like '%1%'
       or card_address like '%2%'
       or card_address like '%3%'
       or card_address like '%4%'
       or card_address like '%5%'
       or card_address like '%6%'
       or card_address like '%7%'
       or card_address like '%8%'
       or card_address like '%9%'
     then 'True' else 'False' end as numbers_in_address

Answer 1

In MYSQL you can do it with Regular Expression Operators

case 
  when card_address REGEXP '[0-9]' then 'True' 
  else 'False' 
end as numbers_in_address

In SQLSERVER you can use pattern in LIKE

 case 
      when card_address  LIKE '%[0-9]%' then 'True' 
      else 'False' 
end as numbers_in_address