I realize this is probably a silly question but I've seen it done before and it was rather straight forward and simple but for the life of me I can't remember how to do it and can't seem to find an example so I thought I'd post it here.
What I am trying to do is get a distinct result set and have a blank item added as well.
As an example if I were running this select statement I would want all of the states to be returned as well as a blank value. The blank value is not contained in the data.
SELECT DISTINCT state
FROM gl_territory