 |
 |
Archives of the TeradataForum
Message Posted: Tue, 19 Oct 2004 @ 16:59:51 GMT
| Subj: | | Re: Reserved Character '_ ' |
| |
| From: | | Dieter Noeth |
Subu Sangameswar wrote:
| | I have data values which has _ character.. | |
| | ex: Person_1, Person_2, Man_Test | |
| | I want to do a search using 'like' keyword but since Teradata uses _ keyword ..It gives me errorneous results .. | |
| | ex: Select column from Table where fieldname like '%_%' | |
Select column from Table where fieldname like '%\_%' escape '\'
The character is removed and the following character is the literal char '_' and not the wildcard.
Check the manual for more details.
Dieter
| |
