KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Which 'not equal' SQL comparison operator does 4D support?
PRODUCT: 4D | VERSION: 13.2 | PLATFORM: Mac & Win
Published On: December 6, 2012

Many SQL implementations feature support for two different 'not equal' comparison operators, usually:

  • <>
  • !=

4D only supports the ANSI-compliant <> operator. This is the operator that appears in the SQL 92 specification. That is to say, 4D's SQL syntax is based on the SQL 92 specification.

The != operator is from Transact-SQL (T-SQL), which is Microsoft's proprietry SQL language. 4D does not directly support T-SQL, though of course much of the syntax overlaps with SQL 92.