I'm trying to concatenate a couple of number fields into a text field with a comma in between and it keeps rounding the numbers off at 4 digits past the decimal. How can I get it to show the full numbers?

Here is the formula that I am using:
CONVERT(VARCHAR, [@field:Num1Address]) + ',' + CONVERT(VARCHAR, [@field:Num2Address])

Both fields are Number Data type.

Result should be:
23.901365999999,54.95645

But the result that I am getting is:
23.9014,54.9564

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'm trying to concatenate a couple of number fields into a text field with a comma in between and it keeps rounding the numbers off at 4 digits past the decimal. How can I get it to show the full numbers?

Here is the formula that I am using:

CONVERT(VARCHAR, [@field:Num1Address]) + ',' + CONVERT(VARCHAR, [@field:Num2Address])

Both fields are Number Data type.

Result should be:

23.901365999999,54.95645

But the result that I am getting is:

23.9014,54.9564

## Link to comment

## Share on other sites

## 2 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.