Dim strCode 'as string

strCode = "J2G 9H8" 'can postal code

in my Firms table :

FirmID FirmName PostalCode
1 FirmA J4X 4Z2 (1 chr)
2 FirmB J2K 3R5 (2 chrs)
3 FirmC J2G 9B7 (4 chrs + space)
4 FirmD J2G 3T7 (3 chrs + space)


So I need a recordset order by number of left chrs like strCode : FirmC, FirmD, FirmB, FirmA


Is this clear ? Don't think so !


Simon