I am having a stored procedure which is used for creating a crystal report. When I run the stored procedure sometimes it gives more than one row of data. I want to check if a particular string exists in any row of a particular column. To make it clear let me give an example
When I run the query I get the below columns
Part Part type
A001 Blanket
A002 Blanket
A003 Toys
What I want to check is if Toys is appearing in any of the row in a formula in crystal reports.
Thanks
Sreejith J