Sorting Queries

[Mina Garas]

Hi Everybody

am trying to sort my queries by alphabet but it doesn't work


i give serial for my queries such as : qry1_Name , Qry2_Name , Qry3_Name .....etc
its working until i reach to qry10_name
and its appear like that
qry1_name
qry10_name
qry2_name
qry3_name
etc

how can i fix it to appear like that
qry1_name
qry2_name
.
.
.
Qry9_name
qry10_name
qry11_name

help me please

thanks alot

[ssanfu]

When you sort text, they are compared left to right. Numbers in a text string are not numbers. They are characters.

To sort like you want, you need the same number of "Numbers". If the maximum "number" will be 3 digits, you will need to have left padding zeros.
For 0 to 99:
qry01_name
qry02_name
.
.
qry98_name
qry99_name


For 0 to 999:
qry001_name
qry002_name
.
.
.
qry098_name
qry099_name
.
.
.
qry998_name
qry999_name

[Mina Garas]

Thanks alot its working