I am looking for a way to convert alphanumeric string to a integer. This will be use to index a primary key on a table that have two character fields as unique ID.
Ex: FldFloor = "001"
FldRoom = "BT007"
Any one done a function that converts the string "001BT007" into a integer?