Crystal Reports search a BLOB field

[PlsHlpKat]

I am using Crystal Reports v11 connecting via ODBC to a SQL Server database. The SQL database has a binary notes field that is showing up in Crystal as a BLOB. I need to be able to search this field. When I try selection expert the field does not even show up to search. I also can not view this field in Crystal. I did a SQL Expression to substring but all that shows up on the report is a bunch of numbers. Below is my SQL Query "PART_BINARY"."BITS" is the binary field:

SELECT "PART_BINARY"."ROWID", "PART_BINARY"."PART_ID", "PART_BINARY"."TYPE", (substring("PART_BINARY"."BITS",1,254)

)
FROM "kevinmfg"."dbo"."PART_BINARY" "PART_BINARY"

Thanks!

Kat

 

[hilfy]

Because it is a binary field and not a text field, you probably won't be able to do a search on it.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.