Convert SQL Server varbinary(max) to Float

Ignition
,
1

I have a float value stored in a SQL Server database as varbinary(max) [from a COTS product] that I need to retrieve in Ignition 8.1.47.

How can I get the float value?

I’m getting different values using CONVERT and CAST and it looks like I’ll need a script to convert it to a Float after I get something I trust from the database. The value, Convert1 and Convert2 have different values with every execution though the database value remains the same.

SQL Server value = 0x014052C00000000000

Named Query:

SELECT TOP(1)
    ,value
    ,CONVERT(varbinary(64), value, 1) AS Convert1
    ,CONVERT(varbinary(64), value, 2) AS Convert2
    ,CAST(value AS nvarchar(max)) AS Cast1
    ,CAST(value AS varchar(120)) AS Cast2
FROM property_vtq
WHERE name = 'TargetValue'
AND id = :name

Sample output of the named query:

image