A question about a blob or memo field

[BigCatMCS]

I'm currently using Crystal 8.5 and I'm trying to find certain key words in a blob field. When I do a select expert or even try a formula, the blob field itself is not there. But when I check the field explorer box or take a peek at the visual linking, the field is there. The problem is that I can't do a query on this field since it doesn't show up in the select expert or formula (when it shows the choice of fields to click on).

I tried to manually write an SQL query ("Show SQL") and I get an error msg saying that it can't do a query on a blob or memo field. What is wrong here? Is there a way around this or maybe versions 9 or 10 allows for a person to do a search for a word in memo fields?

 

[synapsevampire]

CR 8.5 is limited to 254 char fields or less for use in formulas.

Use a SQL Expression, not the Database->Show SQL. Use the syntax for whatever database it is you use, in general it's best to post technical information such as your type of database and it's version when requesting database help.

-k