Hi!
I need to create a crystal report, in which I need a condition where it checks for specific characters in "Comments" Field. This field, datatype in SQL Server is varchar (8000). It converts to Memo field in Crystal Reports. And Crystal reports doesnot allow to put a condition on a Memo field.

I could create the same query easily in Access and in SQL Server and it works too. But now when I have to convert it to Crystal Reports, it refuses to work.

Is there any other way out for this????

Please Help....

Thanks,
Shruti