This worked like a charm! Thanks alot.

Thanks for the reply. But works the same as ISNULL(), my newlines are still shown. My query in view is like this:

SELECT COALESCE (dZ_Field1, '') + CHAR(13) + CHAR(10)...