how to trim all whitespace from a varchar

[Muskaan]

I was under the impression that trim, ltrim and rtrim can remove all whitespace from the ends of a varchar, but it appears that tabs are not removed. Any means of removing tab from the beginning/end of a varchar ?

 

[BJCooperIT]

Use:

rtrim(my_column,'	')

or

ltrim(my_column,'	')

There is a tab between the quotes.

select * from Life where Brain is not null

Consultant/Custom Forms & PL/SQL - Oracle 8.1.7 - Windows 2000
^{When posting code, please use TGML to help readability. Thanks!}

 

[Muskaan]

This helps! Thanks much!

 

[wwwian]

Or even use ltrim(rtrim(col)) !!

 

[carp]

Or just trim(col).

 

[wwwian]

trim(col) is only 8i and upwards of course

 

[carp]

Naturally.