Hi,
There are 2 ways to achieve the task.
1.) As mentioned in the solution by SA above using COALESCE(mname, '')
2.) Using ISNULL(mname, '') for example:
Select IsNull(ColName, '') As ColName From TableName
You can use any one of these methods to check for the null values in your script.
Thanks
Sisir Patro