I have a field in the table that contains records that has '55' in the beginning. I want to have a calculation that once that record has a '55' at the beginning, I want to add '0000' before it. Like for example:
Record 1 has a value of 55556789 then I want the result to be 000055556789.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
KAPITYAN
I have a field in the table that contains records that has '55' in the beginning. I want to have a calculation that once that record has a '55' at the beginning, I want to add '0000' before it. Like for example:
Record 1 has a value of 55556789 then I want the result to be 000055556789.
Can you help me with this?
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.