Handling NuLL in a concatenated statement.
How do I remove any values containing "NULL".
I am trying to concatenate the Type and size into a single value, however, some of the size = "Null".
I want to remove the Null from the concatenated values.
TYPE Size Final value
varchar 8 NO varchar(8)
varchar 10 NO varchar(10)
datetime NULL NO datetime(NULL)
varchar 40 YES varchar(40)
varchar 50 YES varchar(50)
varchar 25 YES varchar(25)
varchar 25 YES varchar(25)
varchar 17 YES varchar(17)
varchar 50 YES varchar(50)
varchar 40 YES varchar(40)
varchar 40 YES varchar(40)
varchar 10 YES varchar(10)
varchar 36 YES varchar(36)
varchar 36 YES varchar(36)
datetime NULL YES datetime(NULL)
datetime NULL YES datetime(NULL)
ASKER
Thanks,