At 02:51 PM 6/5/2013, Dick Fey wrote:
Works perfectly as you show it, but not if you replace the '321' with a var with the same value.
Here's how ... SET VAR vValue INTEGER = 321 SET VAR vNewValue TEXT = (TRIM(FORMAT(.vValue,'000000'))) If used in a report or label, take a look at the "Display Format" option of the control property to achieve desired display format. Have fun! Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 30+ years of continuous innovation! 15 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
