Reported By: Harry de Boer Reported On: 5/22/2007 For: Version 1.02 Build 1
# 2347TRIM Function Not Raising Exception When String Used for Trim Character It seems that only the first char of a column is realy trimmed. The following SQL only removes the 'D'. In dbIsam (3.3) an error occurs that you can only use one char.
Update klanten set postcode = trim(leading 'D-' from postcode)
ResolutionFixed Problem on 5/24/2007 in version 1.03 build 1
Products AffectedElevateDB Additional Software and Utilities ElevateDB VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial