Hex to Dec

[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)



I apologize if this question appears twice.

 

[Jon Spivey]

Hi,
You need sub your field numbers for the numbers, eg
SELECT CONVERT(VARBINARY(8), YourIntegerField) AS HexValue
SELECT CONVERT(INT, YourHexField) AS IntegerValue