Comments on: Rookie Prolem: Using DIGITS() function on an INTEGER valuehttp://itknowledgeexchange.techtarget.com/itanswers/rookie-prolem-using-digits-function-on-an-integer-value/
Thu, 22 Feb 2018 05:06:40 +0000hourly1By: jonty walkerhttp://itknowledgeexchange.techtarget.com/itanswers/rookie-prolem-using-digits-function-on-an-integer-value/#comment-54433
Mon, 07 Jul 2008 16:55:09 +0000#comment-54433Thanks for that info. It turns out that the SQL query was the culprit. The CHAR function forced the SQL into a 80 character length, while the original query was pushing the length outside of the 80 limit – hence the extra charaters (FB vs VB).