General information
Forum:
Microsoft SQL Server
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only