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 command like:
select concat("'", trim(notes), "'") from work_notes On Fri, Apr 17, 2009 at 2:17 PM, Richard Reina <rich...@rushlogistics.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. > > Richard > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=jlyons4...@gmail.com > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com