CASE WHEN LENGTH(TRANSLATE(foo, 
  '#abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ', 
  '#'))<>LENGTH(foo)
 THEN 'Alpha' ELSE 'No Alpha' END