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?