Format Number In Query

[ProgEval]

I want to query a table and reformat a number field in the expression builder.

I want to add a seven and zeros before the number to get to a certain amount of digits.

For example....

Change 698 to 7000698 and 1289 to 7001289

Is there a built in function that makes this easy?

If necessary I could also do it backward if necessary and change 7000698 to 698.

I should know how to do this, but I am not figuring it out.

 

[PHV]

SQL code:
SELECT 7000000 + yourField AS newField

Query grid:
newField: 7000000 + yourField

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886