Reported By: Roy Lambert Reported On: 12/3/2009 For: Version 2.03 Build 6
# 3113CAST Function Not Truncating VARCHAR Columns Properly Using the following SELECT expression, I would expect 1000A1000 as the result, but in fact I get 1000023A1.
CAST(1000023 AS VARCHAR(4)) +'A'+ CAST(1000023 AS VARCHAR(4))
CommentsThe problem was that CAST() was not respecting the length specified for VARCHAR/CHAR columns, and truncating the column as necessary.
ResolutionFixed Problem on 12/4/2009 in version 2.03 build 7
Products AffectedElevateDB Additional Software and Utilities ElevateDB DAC Client-Server ElevateDB DAC Client-Server with Source ElevateDB DAC Standard ElevateDB DAC Standard with Source ElevateDB DAC Trial ElevateDB LCL Standard with Source ElevateDB VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial