What is the SQL operator name for "<>"?

It's "not equal". Look in the list of operators for the database you're using, and find the appropriate section (usually "comparison operators"). For example:

• SQL server
• MySQL
• Oracle
• Postgres

It is the Not Equal operator, but I am going to have to be verbose to get my answer posted because I haven't entered enough characters yet.

<> is NOT Equal to, it's the same as !=

It is the not equals operator. Usage:

select *  
from table
where foo <> 0