Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Jim Lyons (jlyons4435gmail.com)
Date: Fri Apr 17 2009 - 14:33:04 CDT
Works for me. I assume you're only trimming blanks from the beginning
and/or end of the string. I have found that it will not trim tabs. Try a
select concat("'", trim(notes), "'") from work_notes
On Fri, Apr 17, 2009 at 2:17 PM, Richard Reina <richardrushlogistics.com>wrote:
> Hello All,
> I can't get trim to trim the blank space from a TEXT field in the query
> below and was wondering if someone could tell what I am doing wrong?
> SELECT TRIM(notes) FROM work_notes;
> Thanks for any help as I am at a complete loss.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=jlyons4435gmail.com
Web developer / Database administrator