Dear All,
I am new to SQL Server, (I was MySQL users previously), in MySQL I can use
IFNULL(columnname,'') in the SQL command for changing the columns' value to '' if it's NULL Value.. does this function also available in SQL server? or is there any similar function for doing this? ..

please help

Thanks a lot in advance
Regards
Winanjaya