Concatenation of Two Strings

[Pooja Joshi]

When i concate 2 string, if last string value is null than concatination string also null.
Eg. Select fname +' '+ lname as [name] from employe.
If 'lname' is null and 'fname' is pooja,than i am getting null in name field ,please help

[Rabbit]

You can use the ISNULL function to change nulls into an empty string.

ISNULL(someField, '')

[shv214]

You can use ISNULL(), NVL(), IFNULL() and COALESCE() Functions to set any default value like spaces if null is encountered