Hmmm, I get different results.

with Reindeer (ReindeerName)

as

(select 'Dancer Reindeer'

union

select 'Dasher Reindeer'

union

select 'Donner Reindeer'

union

select 'Blitzen Reindeer'

union

select 'Comet Reindeer'

union

select 'Cupid Reindeer'

union

select 'Prancer Reindeer'

union

select 'Vixen Reindeer'

union

select 'Rudolph Reindeer'

union

select 'Olive the Other Reindeer'

)

select Reindeername

from Reindeer

where Reindeername like '%er%'

ORDER BY ReindeerName ASC;

I get 10 but that isn't an option.

MERRY CHRISTMAS

HAPPY HOLIDAYS