>Hello,
>We need to sort on an address column in a GridView, but not by street number, street name. We have 3 fields. One for street number, another for street direction and the third is street name. We wish to sort by street name then by street number numerically and then concatenate these fields so that they form the address field as in: street number, street direction, street name. We wish this to form the address field so that we can use it as a hyperlink.
>
>Alternatively we have the original address field from which these fields were derived, but it would still need to be sorted by street number (numerically), street direction, then street name.
>As in:
>254 Patterson Street
>9 East Texas Street
>211 East Texas Street
>
>If there is no possible answer to this, but it would be possible in another control, we would be open to that, but the address, either the original or a concatenation of three fields, must be a hyperlink.
>Thank you.

Can you sort the data from the inital sql select so that it is the default when no gridview sort order is specified?