nuBuilder Forum

Posted: **Tue Oct 04, 2022 4:10 pm**

Hi,

I have a display object and I am getting data with sql. but I can't format the output. How can i format numbers.

Result :10285760.0000
I want : 10.285.760

Posted: **Tue Oct 04, 2022 5:04 pm**

Give this a go:

Code: Select all

SELECT SUBSTRING_INDEX(FORMAT ('10285760.0000', 3),'.',1);

Of course, replace '10285760.0000' with your column name.

Posted: **Thu Oct 27, 2022 5:23 pm**

Is this solved or do you still need our support?

nuBuilder Forum

Textbox format for display sql

Textbox format for display sql

Re: Textbox format for display sql

Re: Textbox format for display sql