Must be funky friday, can't seem to get it right.
I have a column with a check number in it. Could be 1 to six digits, it
is text
Want that to put that into a new column, using a column expression,
that gives me 6 digit checknum with leading 0's
Tried all suggestions, but using a column name either in place of the
variable or a fixed set of digits will not work.
Thanks all
Dick Fey
On 6/7/2013 2:02 PM, A. Razzak Memon wrote:
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
