Oracle treats empty strings (') as nulls. For the same behavior in SQL Server, you should use isnull(expr,') in string concatenations. ...

English
English (United States)
日本語
Japanese