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.