Hi, I need to retrieve the first name, last name, and phone number of someone in my database. If the phone is null, then I'm supposed to replace that with 'NONE' this is what I have so far.
SELECT ('LAST_NAME',+','+FIRST_NAME) AS NAME, PHONE
FROM MYNAME.DBO.CUSTOMER C WITH (NOLOCK)
IF PHONE IS NULL
THEN PHONE = 'NONE'
This doesn't work. Could someone tell me why???
