How about:

INDEX ON St_Name + TRANSFORM(VAL(St_Num), [@L 99999]) + ....

or something along those lines. This assumes you have digits only in those fields


>Hi all:
>
>I have a address table 1 field for the street name and another field for the street number and another for the suite number all ar character type , I want to sort the table by streets so i did the index on st_name+st_num+suite but than it sorts like that
>
>1
>11
>112
>2
>
>Can someone please help me how to sort it in the proper way with the numeric order.