Given that your language is limited and '||' concatanates stings I would guess at SQL.
CASE WHEN LOWER(foo) = UPPER(foo) THEN 'No Alpha' ELSE 'Alpha' END
However in some SQL varients you can use translate (has an effect like tr///)
CASE WHEN INSTR(TRANSLATE(foo,
'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ',
'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'),
'X')>0
THEN 'Alpha' ELSE 'No Alpha' END
Or Even
CASE WHEN LENGTH(TRANSLATE(foo,
'#abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ',
'#'))<>LENGTH(foo)
THEN 'Alpha' ELSE 'No Alpha' END
Hope it Helps
UnderMine