How would you select all the users, whose phone number is null?

Question

Hello
How would you select all the users, whose phone number is null?
please reply me. i am waiting for your reply.
Thanx

Answer 1

SELECT user_name FROM users WHERE ISNULL(user_phonenumber);