I have a difficulty in sorting the data,i am applying order by clause on two columns concatenated together and the results are displayed without considering the hyphen(-) symbol in resultset.
for example :
i have values in two column as
first Column second column
when apply order by as
select [first Column] + [second column]
order by [first Column] + [second column] desc
the result is shown as follows
here the hyphen symbol is neglected
but i want to consider the hyphen symbol
and need the result as
i tried to get any documents related to it on google but no help
can anyone can help me on this. i am using sql server 2008.
Thanks in advance