Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Null traitement in concatenation

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-04-23 : 23:52:08
Catalin writes "Is there a posibility to make a implicit conversion of null to ''?
For example, if we have select 'a' + null the result is null.
All this I want to be done at server or procedure level because we can make select 'a' + isnull(null,'') Instead of null we have in real life a variable or a column."
   

- Advertisement -