 |
 |
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
this:
SOME_STRING LIKE 'ABC\%%' ESCAPE '\'
| |
