SQL Trim Function

[Abu Nene]

Hi it is a good practise to apply the SQL trim function on all the VARCHAR2 column used in the where clause? For eg.

select * from table A where trim(B) = 'test'

Please advise, thanks.

[Ulf Dittmer]

That depends on whether any whitespace might be significant for the application's purposes or not.

[Jan Cumps]

On several databases, this has a performance impact if the field is indexed. Yorur database might stop using the index if you wrap a function around your field.