query question

Hi,

I have this query below:


select distinct City.CityName
from City


where City.CityID IN (select distinct CityCode as CityID from dest
where dest.destID=@destID)


The result of the query now is null because in my dest table I don't
have any cityCode = 0...


My question is without adding a value 0 for the cityCode in dest
table.. can I change my query in order to return AUTOMATIC if the
cityCode = 0?

I have cityCode from 1 to 45 in my dest table...

Cheers