On 7 Feb 2002, at 8:20, Richard Reina wrote: > I tried both ideas and neither one removed the white spaces. arrr! > :-(
Unfortunately TRIM doesn't remove whitespace (spaces, tabs, carriage returns, linefeeds), as it does in some programming languages. It just removes spaces, unless you specify another character for it to remove instead. Maybe your value has CR and/or LF at the end? Fodder for the idiotic filter: sql,query -- Keith C. Ivey <[EMAIL PROTECTED]> Washington, DC --------------------------------------------------------------------- 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
