Hi

I'm not sure if your "mysql" was a typo... If you mean mssql try this:

DECLARE @t TABLE (txt VARCHAR(30))

INSERT INTO @t

SELECT 'abc'

UNION ALL SELECT NULL

SELECT ISNULL(txt, ' ')

FROM @t

Greets

Flo