Hi All,
Consider I have one table called customer.
custID phoneno Email
1 9999999999 a@gmail.com
2 9999999998 b@yahoo.com
3 Null c@gmail.com
Now i need a query to display Phoneno from customer table and if phoneno column is NULL then it should Email column.
Please Help me.
Regards,
Arun