Comparison Operators 1

[jimnewguy]

Is it possible to do a select statement with a where clause that has a LIKE with multiple values.

Example

Select *
from A
where a.something LIKE ANY ('%ABC%','%BCD%')

 

[nagornyi]

where (a.something LIKE '%ABC%' or a.something LIKE '%BCD%')

 

[jimnewguy]

Thank you

I have 600 different like combinations that need to go into it. Would this still be the best way to handle it?

 

[nagornyi]

I think yes, but would be interested to read here other suggestions, if any..

 

[HimanB]

Hi,
Once way to acive this can to be to pass a complete record group to your query using a Data_parameter form the calling form.

If these 600 values are coming from some table then it is advised to pass the subquery to your report.

HTH
Regards
Himanshu