Cant get TRIM to work?

2009-04-17 Thread Richard Reina 
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=arch...@jab.org

Re: Cant get TRIM to work?

2009-04-17 Thread Curtis Maurand 

http://www.mydigitallife.info/2007/04/23/remove-or-trim-first-or-last-few-characters-in-mysql-database-with-sql/

Richard Reina 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=arch...@jab.org

Re: Cant get TRIM to work?

2009-04-17 Thread Jim Lyons 
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.comwrote:

 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