empty spaces or tabs in my database

[graziaR]

Hi,

I noticed that some text in my database is surrounded by multiple | in bold characters, for instance
|||test|||
What do these || stand for ? Tabs ?
I cannot remove them when I process the text in my code, and it is making me go crazy.
I cannot find the place where they are being inserted. I have trimmed all strings, I think, but no luck.
Any suggestion ?

Thank yoU !

 

[TonyGroves]

I've no idea what they're for, but assuming they are just | characters, you can get rid of them:
[tt]
UPDATE tblname
SET fldname=REPLACE(fldname,'|','')
[/tt]

 

[guelphdad]

Did you import from a file? If so did that file use | as the separator between fields? If it did it is likely that when data was missing from a field that two || appeared in a row, if that is the case you might have corrupt data as some of your fields may have ended up in incorrect columns.