How do I Add a Blank Row to Data from a SQL Query?
Saturday, June 16, 2007
Yesterday I was writing a SQL Query that would return data to be displayed in a drop-down list. Rather than add a row first that contained your typical “Select One” and then bind the data, I wanted the data returned from my SQL Query to contain that row first. I’ve done this in the past and I can’t remember how I did it. This time I decided to use a UNION operator.…more