having trim(BOTH from c.name) translated into having ltrim(rtrim(BOTH)) on DB2

Description

same for LEADING and TRAILING

Environment

None

Activity

Show:
Steve Ebersole
August 11, 2006, 9:43 PM

fixed for db2 and friends much like we did for SQL Server via the use of an "emulation" function which combines ltrim(), rtrim(), and replace() to mimic ANSI trim() functionality.

derby unfortunately does not even have a standard replace function; so there I cheated a little bit and simply said that specifying the replacement character is not supported...

Emmanuel Bernard
August 12, 2006, 2:03 AM

thanks mate

Steve Ebersole
March 21, 2011, 7:04 PM

Bulk closing stale resolved issues

Assignee

Steve Ebersole

Reporter

Emmanuel Bernard

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Blocker
Configure