Hi guys

I have a MySQL database holding property data and each record has a reference number along the form of FLO123N, FLN123S, etc.

What I need to do is order these so that the numbers run 0-9 (ie. the part after FLO and FLN)... how can I order this data based only on the numers?

Thanks,


Dean

I am not sure of an easy way to do that, but you could store the reference number as 2 fields in the database and then order them by the second field.  So when you store these numbers, store them with the first 3 characters in the first field and the rest in the second field.