dear friends,
can anyone help.
The column æÂÂ…ontact_Id?has both character codes and integers in it. Ex.
1, 11, 2, KTWV, KNX?and so on
SELECT * FROM USERS
ORDER BY Contact_ID
Returns the integers out of order.
1, 10,11, 2, 3 treating them as characters.
Q: how so I group by as integer? So the result has the integers in order?
Is the a ORDER BY AS INTEGER function?
can anyone help.
The column æÂÂ…ontact_Id?has both character codes and integers in it. Ex.
1, 11, 2, KTWV, KNX?and so on
SELECT * FROM USERS
ORDER BY Contact_ID
Returns the integers out of order.
1, 10,11, 2, 3 treating them as characters.
Q: how so I group by as integer? So the result has the integers in order?
Is the a ORDER BY AS INTEGER function?