Forums Register Login

SQL Trim Function

+Pie Number of slices to send: Send
Hi it is a good practise to apply the SQL trim function on all the VARCHAR2 column used in the where clause? For eg.



Please advise, thanks.
+Pie Number of slices to send: Send
That depends on whether any whitespace might be significant for the application's purposes or not.
+Pie Number of slices to send: Send
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.
Paper jam tastes about as you would expect. Try some on this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 1955 times.
Similar Threads
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 ?
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 14:55:35.