I've got a SPROC that is returning Nulls for some records. 'name' has data in all the fields but 'secondName' is optional. I'm guessing thats why I'm getting Nulls for some records.
How best is it to deal with Nulls in this situation?
Thanks in advance,
ALTER PROCEDURE dbo.locationsListing
SELECT name = (name + secondName + ' (' + ')'), locationID FROM locations