Look up 'ISNULL' and COALESCE' in BOL.
"Greg" <gmanshipwvmls.com> a écrit dans le message de news: [email]us3E67MQDHA.3192tk2msftngp13.phx.gbl[/email]...
> I have setup a view with a column that combines address fields as seen
> AddNum + N' ' + AddDir + N' ' + AddStreet
> The obvious problem is that if there is no data in the AddDir field, it
> returns the address as <NULL>. What is the best way of returning all the
> addresses regardless if data is missing in any of the three fields. Any
> help ...