WHERE *field* = '%/%'...

[bubbisthedog]

Hello, all. Great forum.

I'm querying a DB2 table, trying to filter records according to whether or not the, let's say, 'field' value, contains a forward slash (/). I've tried

WHERE *field* = '%\/\%'

using the backslash (\) to escape the (/) to no avail (records returned are 0). Could someone please suggest another option that I have?

Thank you kindly for any assistance!

Regards,

bubbis

 

[Zathras]

You need to use the [tt]LIKE[/tt] operator instead of the [tt]=[/tt] sign

 

[bubbisthedog]

Thanks, Zathras! Can't believe I forgot about using "LIKE." I really appreciate the help!

Regards,

bubbis