March 15, 2014 at 8:44 am
i have sql table coloum house_no
display house no order .....
8-3-132/77A
8-3-132/77/A
8-3-132/77/A
8-3-132/75
8-3-132/53
8-3-132/53
8-3-132/3
8-3-132/3
8-3-132/3
8-3-132/3
display o/p like
8-3-132/3
8-3-132/3
8-3-132/3
8-3-132/3
8-3-132/53
8-3-132/53
8-3-132/75
8-3-132/77A
8-3-132/77/A
8-3-132/77/A
March 15, 2014 at 8:55 am
SELECT houseno
FROM <yourtable>
ORDER BY houseno
however...I have a suspicion that you have over simplified your requirements .......???
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 15, 2014 at 9:05 am
using ur code
not display ordey
if my table like
3-2-10
3-2-100
3-2-11
3-2-3
3-2-33
3-2-4
using ur code display order o/p like
3-2-10
3-2-11
3-2-100
3-2-3
3-2-33
3-2-4
March 15, 2014 at 9:09 am
have we been here before ???
http://qa.sqlservercentral.com/Forums/Topic1520462-3077-1.aspx
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 15, 2014 at 9:37 am
i want output like display fourthpart order
8-3-132/3
8-3-132/3
8-3-132/3
8-3-132/3
8-3-132/53
8-3-132/53
8-3-132/75
8-3-132/77A
8-3-132/77/A
8-3-132/77/A
March 15, 2014 at 10:20 am
SELECT house_no
FROM <yourtable>
ORDER BY REPLACE(house_no, '-', '')
you have asked this question numerous times......can you please explain why the solutions provided have not so far solved your problem
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply