A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
SQL Trim Function
Joined: Nov 13, 2008
May 18, 2009 00:57:56
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.
Joined: Mar 22, 2005
May 18, 2009 01:32:37
That depends on whether any whitespace might be significant for the application's purposes or not.
Joined: Dec 20, 2006
May 18, 2009 03:55:10
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.
OCUP UML fundamental and ITIL foundation
Have you checked out
subject: SQL Trim Function
q from abhilash mock exam on strings.
Using Trim function in Hibernate
using Strings to query database??
Login JSP page using mysql(DB)
Is there any trim function in xsl ?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015