MySQL Version: 3.23.49 OS: Win 98 Query 1: select length ('abc') returns You have an error in your SQL syntax near '('abc')' at line 1
Query2: select length('abc') returns 3: OK Note the space between the 'h' and '(' in Query 1. The parser does not like this space... The same problem occurs with all the functions. Thanks, Patrice Khawam. __________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php