Is it even possible to do a if statement in a select? If so how would I get this to work??

I know this doesn't work, but if it can be fixed please so me the correct syntex.

select if(LAST_NAME = 'SMITH' then 'JONES' else LAST_NAME), PHONE_NUMBER, ZIPCODE from T_ADDRESS


Thanks...

The CASE expression will do what you want:

select case when LAST_NAME = 'SMITH' then 'JONES' else LAST_NAME end as LastName, PHONE_NUMBER, ZIPCODE from T_ADDRESS

Jeff Mason
[email protected]

THANK YOU!!! I knew it was possible because I had done it in the past, but I haven't worked in SQL so long, I forgot about CASE.

THANKS AGAIN..