Archives of the TeradataForum
Message Posted: Fri, 20 Jul 2007 @ 21:00:46 GMT
Subj: | | Re: MINUS works well; EXCEPT has an exception |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Friday, July 20, 2007 14:46 -->
The error is your SUBSTRING expression. No idea why MINUS versus EXCEPT makes a difference.
Valid syntax is either
SUBSTR(string,startpos,len)
SUBSTRING(string FROM startpos FOR len)
If you want full ANSI compliance, consider using the ANSI function syntax for SUBSTRING and use POSITION instead of INDEX
|