spikes wrote:
ansi sql compliance includes views, stored proc, tirggers, etc. odbc standards functions includes power(), space(0, cot(), truncat(),etc.
ODBC is a specification for a database API and _none_ of the DB servers complies with it as their _core_. only the DB's ODBC driver should comply with the ODBC specification (level 1,2,3).
if you'll check on the MSDN website, the ODBC function's you've mentioned doesn't exist on the ODBC specs and not even on the ODBC reserved words. and those were merely string or arithmetic functions that can be user-defined and shouldn't have a bearing for SQL compliance.
and if you'll check on the MySQL website, you'll see that MySQL is also complying with ANSI SQL-92 standard _but_ with some extensions.
NOTE: afaik, none of the DB servers strictly or 100% complies with the ANSI SQL standard.
=)
-- Ariz C. Jacinto, ECE Systems Operations SPI Technologies-PS
-- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
