Using hex value in load script

[#1]

I want to use this where clause in a script when loading data from a SQL table

WHERE Create_Date > '2012-01-01' AND ID = '0000000000001D5E';

I've checked the hex value in the table and its oorrect but this statement doesn't return any values.

I've created a list box and displayed the ID field and I can filter on this value and I also copied the cell value to paste in to the above statement.

Any ideas why this fails to return any records...the date bit works correctly on its own

[rwunderlich · Accepted solution]

To use a hex value, you must preceed it with "0x" (assuming MS SQLServer). For example:

ID=0x0000000000001D5E

No quotes around the value.

-Rob

http://robwunderlich.com

[#3]

Thanks Rob...that solved it.