I need help in SQL table

[Kashan]

i have a table named tblPerson. There is a field in it named PersonID. the data type of the PersonID is nvarchar(5).
there were 9999 rows in the table when i added the series of 10000-10010 it is not sorting the data as it should it. it is showing 10001 - 10010 after the rows of 1000 which is wrong why is it what should i do?

currently
1000
10001
10002
10003
1001

required
1000
1001
10001
10002
10003

[hariharanmca]

i have a table named tblPerson. There is a field in it named PersonID. the data type of the PersonID is nvarchar(5).
there were 9999 rows in the table when i added the series of 10000-10010 it is not sorting the data as it should it. it is showing 10001 - 10010 after the rows of 1000 which is wrong why is it what should i do?

currently
1000
10001
10002
10003
1001

required
1000
1001
10001
10002
10003

if u sort the character it just by number of charecter serial

ex :
 for 4 dig
1000
1000
1000
1000
1001
 
 
 for 5th dig
1000
10001
10002
10003
1001

got the concept?

[Kashan]

if u sort the character it just by number of charecter serial

ex :
 for 4 dig
1000
1000
1000
1000
1001
 
 
 for 5th dig
1000
10001
10002
10003
1001

got the concept?

hi,
i did not understand what u wanted to say.
kindly clear by clearified example .
Thanks

[hariharanmca]

hi,
i did not understand what u wanted to say.
kindly clear by clearified example .
Thanks

1. You told the data type is varchar.
2. So, it will not sort the numbers lesser to greater
3. it will look for the order 0 – 9 like

Ex :

For 1 digit it’ll be correct
0
1
2
3
4
5
6
7
8
9

For 2 digit it’ll change like
0
1
10
11
12
13
14
15
16
17
18
19
2
20
21
.
.
.
Etc…,

[hariharanmca]

hi,
i did not understand what u wanted to say.
kindly clear by clearified example .
Thanks

did you got the concept

[Vidhura]

i have a table named tblPerson. There is a field in it named PersonID. the data type of the PersonID is nvarchar(5).
there were 9999 rows in the table when i added the series of 10000-10010 it is not sorting the data as it should it. it is showing 10001 - 10010 after the rows of 1000 which is wrong why is it what should i do?

currently
1000
10001
10002
10003
1001

required
1000
1001
10001
10002
10003

Change the PersonID to int type

[hariharanmca]

Change the PersonID to int type

Absolutely. You've to cahnge.........