Search SSWUG.ORG:



DATABASES

Trimming the fun? LTRIM and RTRIM extended This is an off-site link.  Please review our Terms of Service for additional information.


(Henrik Loeser) One of the newer features in DB2 is extended trimming capability in the functions LTRIM and RTRIM. Since Fixpack 2 of DB2 10.1 both functions have an optional second parameter which is used to specify the characters to be removed from the beginning or end of a string.

Read this article..







comments powered by Disqus