Hexidecimal to Decimal

[Andy]

I'm looking for a way to convert hexidecimal to decimal in an Access database
that is on a SQL server. The database is updated by barcodes being scanned
into FP asp pages. Some of the pages have SQL statements that sends the data
to specific records. My question is, is it possible to use a SQL statement to
convert hex to dec and then send to the database?

 

[Jon Spivey]

Here you go
http://www.aspfaq.com/show.asp?id=2338

 

[Andy]

Thanks

Here you go
http://www.aspfaq.com/show.asp?id=2338

 

[AndyB]

Can anybody tell me how to use the below for converting hex to dec? I'm
trying to use it in FP200 .asp pages that uses a form to send to a database
on a SQL server. Where do I put it and do I need to edit it to reflect form
field names or database fields names? I've tried various ways and can't get
it to work. Any input would be appreciated.


SELECT 'Int -> Hex'

SELECT CONVERT(VARBINARY(8), 16777215)

SELECT 'Hex -> Int'

SELECT CONVERT(INT, 0xFFFFFF)

 

[Bishwa]

You can use the following function:

Val("&h"&Field Name)
Where Field Name is the name of your field in the table you want to convert.

Thanx
Bishwa