Re: Conversion problem with cast function

[Alberto Molero]

Don't work for me ( your solution work, but not for me in this case :D )
I need that the HEX value have a fixed length.
Sample:

/*tResult is a table that contains only one column. (info varbinary(8000))*/
Insert Into tresult
Select Concat(Convert(ifnull(customerName, ''), binary(20)),
Convert(ifnull(customerID, 0), binary(4))
From Customers

/*
customerName Varchar(20) - THE CONVERSION WORK FINE
customerID Integer - THE CONVERSION DOESN'T WORK
*/

The main problem of your solution is that i can't fix the length of the value.