Text data from SQL Server binary field

Hi All,

I am trying to extract the binary data from a SQL Server binary (image,null) field. The data is text and SQL Server select shows the data as 0x504D2D35322D31302D32302D3330....

I also have a field that gives the length of the binary field.

Any ideas how to get that into a string?

Thanks,
Jeff

Well, I just used Left() function and it worked! It just does not show in the query test.

Thanks for reading!

Jeff