>Hi everybody,
>
>In SQL Server is there a quick way to automatically insert empty value instead of NULL? I have a long Insert-SQL command with LEFT JOIN and don't want to use ISNULL for every field.
>
>Researching on this in the meantime myself.
>
>Thanks in advance.

Quick research revealed that there is no way so I manually adjusted the statement.