Loading

display order

JAYRAM

12y1.3k

i have table like below

h.no

3-5-33/1
3-5-33/97
3-5-33/12
3-5-33/111
3-5-33/2
3-5-33/9
3-5-33/44

display o/p like
3-5-33/1
3-5-33/2
3-5-33/9
3-5-33/12
3-5-33/44
3-5-33/111

iam using select houseno from tablename order by houseno

but o/p not shows above formate
it display like

houseno
3-5-33/1
3-5-33/111
3-5-33/12
3-5-33/2
3-5-33/44
3-5-33/9

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
Try:

SELECT houseno from tablename
ORDER BY CAST(RIGHT(houseno, LEN(houseno) - CHARINDEX('/', houseno)) AS INT)
Sanjay Kumar12y ago
Hi

try this

order by clause ASC and DESC

select houseno from tablename order by houseno ASC