Sql using OR in a CASE statement

Question

I need to check if a word that starts with a vowel and write 'an' or 'a' accordingly.

I could just go and write:

CASE substring(word, 1, 1) when 'a' then write an when 'i' write an

and so on.

Anyone has an easier way to do it? Just say if it's a, i, o, u or e - write 'an' else write 'a'?

not about problem but result will probably wrong if string is 'university' — hkutluay, Jan 02 '13 at 11:33

score 2 · Accepted Answer · answered Jan 02 '13 at 11:33

2

CASE WHEN substring(word, 1, 1) IN ('a', 'e', 'i', 'o', 'u')
         THEN 'an'
  -- WHEN 

END

answered Jan 02 '13 at 11:33

ypercubeᵀᴹ

score 0 · Answer 2 · answered Jan 02 '13 at 12:07

0

(CASE WHEN left(word, 1) IN ('a', 'e', 'i', 'o', 'u')  THEN 'an' ELSE 'a' END)

answered Jan 02 '13 at 12:07

TechDo

2 Answers2