SQL Query
 

Anyone good at SQL here?

I am trying to make a query that replaces a tab in a column after every entry in that column. I started using trim(), but I don't think I know how to use it corrrectly.

Here is what I have so far:


Select fullname_ from members_ and TRIM(BOTH ' ' members_);


What am i doing wrong?

dont do it :Oh crap

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

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

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?

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

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

Thanks again!!

WOJ gives advice? WOW!

Also, you can TEST it first by doing this,

SELECT TRIM(fullname_) from members_ SET