SELECT IF ... HELP Please.
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