Skip to Content
0
Apr 14, 2014 at 09:11 AM

How to find a string from a set of records?

19 Views

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