Archives of the TeradataForum

Message Posted: Tue, 26 Apr 2005 @ 08:41:25 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: Strange syntax on in clauses

From:		Victor Sokovin

Is this type of concatenation limited to IN-Clauses?

Because

          > Select '01' '02'

is resulting in '01' with the column name of '02'?

Just to add to the confusion ...

     SELECT '01' '02'
     FROM dual

is not recognized as valid syntax by Oracle.

However,

     SELECT '01' '02' ,

if run on Sybase or SQL Server, returns 01 in column 02. If I omit the blank between '01' and '02', than the output is the same on the three databases: 01'02.

Neither Oracle, SQL Server or Sybase seem to understand the IN-list syntax like IN ('01' '02','03'), which Teradata manages to parse, as you have noticed. They all generate an SQL error. With the blank omitted, they are happy to parse it. So, it looks like Teradata might be ahead of the competition in this area of ANSI compliance (at least by 3:1), if their interpretation of the ANSI recommendations is correct, of course. I don't have access to the ANSI docs right now but will be able to look them up early next week.

Regards,

Victor