Hello,
I have a problem with sorting on a numeric value, the sorting looks like a sort of a string (while field schuifid in table is numeric).
This is the sql :
SELECT schuifid, omschrijving FROM schuiven UNION SELECT"<Alle>"," " FROM schuiven ORDER BY schuifID;
The result = 1,10,100,101,11,110... in stead of 1,10,11,100,101,110.
Can someone help me with this?
Thanks in advance.
Anna