Archives of the TeradataForum

Message Posted: Thu, 13 Nov 2008 @ 11:20:08 GMT

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

          > select count(*) from SRCTEST.CUSTOMER
          >       where SOCIAL_SECURITY NOT = '103-183-336'

Really? Interesting. It would not occur to me to use this syntax but there you go.

Perhaps it is worth standing still for a moment to think of ANSI compliance here. What are the ANSI requirements in this area?

Quick tests on Oracle and SQL Server show that both of them have no problems with the "<>" and "!=" forms and both of them do not understand the "NOT =".

So, which of these three databases (Teradata, SQL Server, Oracle) are ANSI compliant?

Victor

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