Skip to Content
0
Former Member
Jun 21, 2010 at 04:45 AM

LIKE function in DS

91 Views

Hi guys

I need the 'LIKE' function for the string comparisons but apparently there is no such a function in Data Services. We use version 12.2.

I need to implement for example:

[My query]

In WHERE section: Subrub LIKE '%London%'

So based on the LIKE function all below results would be valid:

West London

North London

South London

London North

...

I know I can include all different senarios in my WHERE section of the query but there are too many cases, is there any way to implement LIKE in DS?

Thanks.