Wild Cards question.

[CapsuleCorpJX]

What is the escape character for wild-cards?

% means 0 to many characters.
_ means 1 character.

What if I want to search for "_" literally?

 

[BillDHS]

If I remember correctly it is the backslash \.

 

[jgerstb]

From the SQL reference - Volume 5

The following example illustrates the use of ESCAPE:

To look for the pattern ‘95%’ in a string such as ‘Result is 95% effective’, if Result is the field to be checked, use:

WHERE Result LIKE ‘%95Z%%’ ESCAPE ‘Z’

This clause finds the value ‘95%’.

 

[CapsuleCorpJX]

Found the answer:

...
TRIM(TESTFIELD) like 'Testing_me'c || '_Y'
...

the c char means anything before this is a literal.

So here are examples that will match the condition above:
Testing_mexY
Testing_me4Y
Testing_me_Y

Those that will not match:
TestingXme_Y
Testing_meXXY

 

[dnoeth]

Hi CapsuleCorpJX,
interesting, i've never seen that "'....'c" before, i only knew it from Hexadecimal Literals.

But to disappoint you, it returns TestingXme_Y, too (at least when i run that query).

Why don't you simply use jgerstb's proposal, it's Standard SQL:
TRIM(TESTFIELD) like 'Testing\_me_Y' ESCAPE '\'

Dieter