Hi Andrew,

Thanks so much for your quick reply.

Yes my Tally table is missing the number 0. I have used your suggested SQL statemensts and it works fine now.

Thanks...

Hi Andrew,

Thanks very much for your detailed explanation on how to convert the Hex string into a binary field. I've not seen the use of the Tally table before...

Thanks Bruce and Jeff.

Sorry for the delay in responding to your reply.

In SQL Management Studio when I run Transac SQL the Binary(20) field looks like this:

0x0000000000014C3130303039392D353020434164

We have noticed that...