sorting - (1st post doesnt seem to appear - sorry if it has)

[Newbie]

I want to be able to sort a text field as if it were a number field - 99.9%
of the data is number - I can't change the field type :-(

I can sort the query that the report is based on using (SQL):

ORDER BY Operator, TX.orderno, TX.opno, Case
patindex('%[^0-9]%',TX.PassportNo) when 0 then cast (TX.PassportNo as int)
end, TX.PassportNo;

Is there something similar for sorting the report?

Thanks