 |
 |
Archives of the TeradataForum
Message Posted: Wed, 10 Dec 2003 @ 15:44:33 GMT
| Subj: | | Re: SQL Standard for the "%" wildcard on the LIKE predicate. |
| |
| From: | | Fuller, Joe |
According to ANSI (and it just makes sense) 'NEW YORK ' does not match '%YORK'. If using CHAR (perhaps VARCHAR would be more
appropriate in this instance?) each character counts. So I have found either trimming or using '%YORK%' to be the best alternative. Gotta
watch those CHARs, they can be a gotcha if not careful! LOL (And BTW, ANSI is not a votable concept as much as we would wish otherwise!) ;-
)
Best Regards,
Joe Fuller
Sr Data Warehouse Consultant
| |
