Archives of the TeradataForum
Message Posted: Wed, 24 Apr 2002 @ 19:07:34 GMT
| Subj: || || Re: String matching and escape character |
| From: || || Geoffrey Rommel |
| ||I would like to know what the escape character is for string matching. For example, if I say:|| |
| ||I will get any string starts with ABC. But how do I go about matching exactly 4 characters with "ABC and percentile"?|| |
I think what you want is "'ABC%', followed by anything". If so, you can use any character as the escape by specifying ESCAPE, like
SOME_STRING LIKE 'ABC\%%' ESCAPE '\'