Textbox format for display sql

[acroporax]

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

[kev1n]

Give this a go:

Code: Select all

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

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

[kev1n]

Is this solved or do you still need our support?