SQL Query put a word in a field instead of 0?

Question

When i run sql query such as;

Select 
    F1 as name, 
    F2 as phone 
from Table where condition = true

If F2 = 0 i need to that field to be No Phone Number instead of null or 0

Answer 1

You can do that with a CASE statement:

SELECT
CASE WHEN F2 = '0' THEN '(No Phone Number)' ELSE F2 END AS Phone
...

Answer 2

SELECT
CASE WHEN F2 = '0' OR F2 IS NULL THEN '(No Phone Number)' ELSE F2 END AS Phone 

Answer 3

You will need to use CASE as;

SELECT 
    F1 As name, 
    CASE WHEN F2 IS NULL OR F2 = '0' THEN 'No Phone Number' ELSE F2 END As phone
FROM Table
WHERE condition = 'true'