CASE WHEN LOWER(foo) = UPPER(foo) THEN 'No Alpha' ELSE 'Alpha' END

##</code><code>##

CASE WHEN INSTR(TRANSLATE(foo, 
  'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ', 
  'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'),    
'X')>0
 THEN 'Alpha' ELSE 'No Alpha' END

##</code><code>##

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