Virtual Brain/SQL 1 SQL-92 Standard - SQL-92 is the official standard. However, many databases do not completely conform to it or at least add something. ISO-site {link:search query|http://www.iso.org/iso/en/StandardsQueryFormHandler.StandardsQueryFormHandler?scope=CATALOGUE&sortOrder=ISO&committee=ALL&isoDocType=ALL&title=true&keyword=SQL}. - SQL-92 Validator: http://developer.mimer.com/validator/parser92/index.tml - Syntax diagrams: http://www-dbs.inf.ethz.ch/~isk/WS_97/syntax_diagramme/ 1 Insert / Update I always mix up the Update and Insert Syntax... Here we go: {code:sql} UPDATE tbl_name [, tbl_name ...] SET col_name1=expr1 [, col_name2=expr2 ...] [WHERE where_definition] {code} {code:sql} INSERT [INTO] tbl_name [(col_name,...)] VALUES ({expr | DEFAULT},...),(...),... or INSERT [INTO] tbl_name SET col_name={expr | DEFAULT}, ... {code} As usual, this snip will be of no use. After writing something down, memory usually makes it persistent :-) 2004-12-28 13:37:25.318 2004-12-28 13:27:12.353