order by based on last integers

Question

0.00/5 (No votes)

See more:

Hi In my asp.net application
I want to sort employees based on their code

code is

emp 1000
emp 23
emp 33

i want result in this order

emp23
emp33
emp1000

pls help me

Posted 11-Aug-11 0:18am

Shibiny

Updated 11-Aug-11 0:51am

Pravin Patil, Mumbai

v2

Add a Solution

Comments

Om Prakash Pant 11-Aug-11 6:25am

emp code and id stored in separate columns or in single column?

Praveen Kullu 11-Aug-11 9:12am

Please see my updated solution .

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mahendra.p25 · Answer 1 · 2011-08-11T00:32:00

Solution 2

try in this way

DECLARE @Table TABLE (ID VARCHAR(30))

INSERT @Table
SELECT 'emp1000' UNION ALL
SELECT 'emp23' UNION ALL
SELECT 'emp33' 


SELECT ID
FROM @Table
ORDER BY SPACE(50 - LEN(ID))+ ID ASC

Posted 11-Aug-11 0:32am

Mahendra.p25

thatraja · Answer 2 · 2011-08-11T00:48:00

Solution 3

You store only Integer value in DB. while querying use the below way

SQL

SELECT ID, 'emp'+ID AS EmpID FROM TableName ORDER BY ID

Posted 11-Aug-11 0:48am

thatraja

nagendrathecoder · Answer 3 · 2011-08-11T01:01:00

Solution 5

It seems that "emp" is common for all records.
If that the case,
you can trim "emp" from all rows,
then store all records in an ArrayList,
then Sort that ArrayList,
and finally display all objects from ArrayList by appending "emp" to it.

Posted 11-Aug-11 1:01am

nagendrathecoder

Debojyoti Majumder · Answer 4 · 2011-08-11T00:25:00

Solution 1

Seems like you want to trim spaces.
You can use String.Trim method.

Refer this link
http://msdn.microsoft.com/en-us/library/system.string.trim.aspx[^]

Posted 11-Aug-11 0:25am

Debojyoti Majumder

Comments

Shibiny 11-Aug-11 6:29am

no. i mean that, i want to sort based on last numbers .

Praveen Kullu · Answer 5 · 2011-08-11T00:52:00

Solution 4

I believe you don't have a table where there are repeating values (i.e emp) in a column. If the employee name and code is in one column (like emp100,emp23,emp33) ,

SQL

select employeename from tablename order by len(employeename), employeename asc

Posted 11-Aug-11 0:52am

Praveen Kullu

Updated 11-Aug-11 3:21am

v4

Comments

nagendrathecoder 11-Aug-11 7:03am

i guess this won't do rightly.....it will consider emp230 before emp34.

Praveen Kullu 11-Aug-11 9:09am

Please check my updated solution , this one works