 |
 |
Archives of the TeradataForum
Message Posted: Wed, 10 Dec 2003 @ 14:21:48 GMT
| Subj: | | Re: SQL Standard for the "%" wildcard on the LIKE predicate. |
| |
| From: | | Victor Sokovin |
| | Workaround it to use TRIM to get rid of any 'padding' shoved on the end of your string to pad it up to a CHAR(10). | |
Why do you say 'padding'? Genuine right-padding with spaces always takes place with the fixed-length CHAR(n) data types, also in
R4. That's a part of the data type definition, not a bug. The extra spaces are really stored on the disk and cost you one byte each.
Regards,
Victor
| |
