I have setup a test view in t-sql 2012 which is as follows:
CREATE VIEW [dbo].[vDirectCer]
select top 100 percent *
order by mailAddress desc,city desc ,state desc ,zip desc
However the sql I listed does not work as I needed it to.
What I need if any or all of the fields called mailAddress,city,state ,zip
contain null or spaces, the all 4 columns in the view need to display spaces.
In addition when these fields display spaces in the view, those records should be displayed first in the list of records that are displayed.
Thus would you show me the -t-sql 2012 that can be used to accomplish this goal?