Table View Numer Formatting

Hi MikeG and  JackLacava ,

After beeing testing a lot of different options, I have solve it. JackLacava you was right. If I use FORMAT in my SQL, the column is stored as Text and it's imposible to solve the issue. 

At last, the way to obtain the column in number format has been this one: 

1. Define the text columns as Decimal. In my case, the columns that contains "Year":

2. After that, the system is making an error derivated from the culture. I don't know why exactly, but if you are using ',' as decimal and '.' for thousands (for example: 1.150,12), the table view shows 115012. It seems that it can't be able to read ',' as decimal separator. 

3. To solve it, when I'm inserting the rows, for number columns, I'm replacing ',' for '.'.

Whit this, the system understand that the '.' is the decimal separator and it shows perfectly. The only thing left is the thousand indicator. I don't find a way to solve it.

Hope it help you!

Albert