Victoria Reznichenko <victoria.rezniche...@ensita.net> writes: > "Holly Chamberlain" <hol...@golighthouse.com> wrote: > >> >> Does anyone have a good site that contains the current SQL standard? Or >> does anyone know is ISNULL() and IFNULL(), and similar null testing >> functions, standard SQL or extensions to SQL? > > No, there are no such functions in the SQL-99. In the standard you can > find IS [NOT] NULL to see if value is NULL or not.
There is[1]. The SQL standard defines following special CASE-END shortcut functions: NULLIF() To convert ITEM to NULL COALESCE() To convert NULL to ITEM (this is what you usually want) Jari Aalto ----------------------------------------------------------------------- [1] The SQL:1992 standard, heading "6.9 <case expression>". http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt <case abbreviation> ::= NULLIF <left paren> <value expression> <comma> <value expression> <right paren> | COALESCE <left paren> <value expression> { <comma> <value expression> }... <right paren> As standards are backward compatible, this applies to SQL:2008 as well. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org