I have one question related to SQL Server. But there is not forum on this. so here is my Question.
While accessing multiple columns value in a single alias column we right query as follows.
Select FNAME +' '+ MNAME +' '+ LNAME as NAME from Cust_Master
Am I right ?
But the question is when one of values from FNAME, MNAME, LNAME if comes NULL then my NAME filed will be NULL.
How to avoid this?? Any one have solution for this.
Note : I am using this Query for Creating VIEW.
Thanks. Have a Lovely Time. :pretty: