SQL Query

**cyber_ninja** · 06-09-2005, 05:07 PM

dont do it

**OptMediaJohn** · 06-09-2005, 05:08 PM

Don't do it? Why? It has to be done...

**woj** · 06-09-2005, 05:10 PM

can you try explaining again what you are trying to do?

**OptMediaJohn** · 06-09-2005, 05:12 PM

Ok, I have a table members_ with a column fullname_ . The column fullname_ has a tab after every name (caused from the import of this table into this database). I want to remove this tab after every name in that column. Someone pointed me to TRIM, however I don't think I am doing that so well.

Does that make sense?

**woj** · 06-09-2005, 05:16 PM

make a backup of the table,
and then try something like this perhaps?
UPDATE members_ SET fullname_=TRIM(fullname_)

If you are still having problems you can hit me up on icq:33375924

**OptMediaJohn** · 06-09-2005, 05:34 PM

Big thanks to WOJ on this, looks like its running perfectly!

Thanks again!!

**V_RocKs** · 06-10-2005, 12:03 AM

WOJ gives advice? WOW!

Also, you can TEST it first by doing this,

SELECT TRIM(fullname_) from members_ SET

SQL Query

SQL Query

Comment

Comment

Comment

Comment

Comment

Comment

Comment