In my table, I have a column with nchar data (4) (before it was nvarchar (4), but gave in the same), in the form users choose in a select to be able to fill and send to the table. >
In this select, I have for example the data "250", "1166", "2130" when I make a report on my web page (in asc), and I ask to sort, in ascending order, the data of this column .. the 250 stays after 1166, as if it were "2500", but in fact it should appear before , since the 250 should be considered as "0250".
I put, in my ASC file, to format as formatnumber (Cint (data), "0000")
but it did not work.
Does anyone know how to fix it?
Thank you