Patrice,
Thursday, April 04, 2002, 4:41:24 AM, you wrote:
P> MySQL Version: 3.23.49
P> OS: Win 98
P> Query 1: select length ('abc') returns
P> You have an error in your SQL syntax near '('abc')' at
P> line 1
P> Query2: select length('abc') returns 3: OK
P> Note the space between the 'h' and '(' in Query 1. The
P> parser does not like this space...
P> The same problem occurs with all the functions.
It's a well-known feature. You can run MySQL in ANSI mode to have any
number of spaces between function name and brackets, look at:
http://www.mysql.com/doc/A/N/ANSI_mode.html
P> Thanks,
P> Patrice Khawam.
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.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
