varbinary handling

[noexit]

I'm executing a select statement that brings back 10 fields, I'm using odbc....  One of the field values I need to use in a later query is defined as varbinary in the database (MSSQL 2005).

 

I'm not having any luck in capturing the value in a variable so I can use it again in later query where this value matches one keyfield.

 

Thanks.

[hitman6003]

try casting the varbinary variable to varbinary in the sql query...

 

SELECT * FROM tablename WHERE varbinary_column = CAST('$varbinary_php_var' AS varbinary)