how to get the int order sorting asc, the order field already in varchar type
- by karthikeyan1211
I have the field receiptno as varchar and want to sort this, if normal order sorting getting wrong sorting value. Then have the idea to sort the field by convert int type.
Is there anyway to converting int type in query itself