>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?
You could run a CRC algorithm on it. You would have a probability of uniqueness but not 100% though. You would easily be able to account for collision though.
Brian Seekford
Seekford Solutions, Inc.http://www.SeekfordSolutions.comInternet ActiveX Controls and .NET Class Libraries.
SMTP/S FTP POP3/S HTTP/S SNTP MIME PING WHOIS TRACEROUTE NNTP DNS MX
Base64, UUEncode, yEnc, MD5, SHA1, URL, Quoted-Printable.
Resizer and Tooltips
Email Verification and more. Check us out!