Archives of the TeradataForum
Message Posted: Tue, 11 Feb 2003 @ 19:54:11 GMT
The real question in my mind is why the first query works. I believe your problem is that LENGTH(...) isn't a standard SQL function.
use something like
CHARACTER_LENGTH(TRIM(TRAILING FROM pc.postl_cd)) =9
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|