# Sorting works strangely (

**URL:** https://community.nocodb.com/t/sorting-works-strangely/1649
**Category:** Grid-View
**Created:** [February 7, 2025, 1:52pm UTC](https://community.nocodb.com/t/sorting-works-strangely/1649 "2025-02-07T13:52:06Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![isckan27](https://avatars.discourse-cdn.com/v4/letter/i/7feea3/32.png) [@isckan27](https://community.nocodb.com/u/isckan27)
#### Post date: [February 7, 2025, 1:52pm UTC](https://community.nocodb.com/t/sorting-works-strangely/1649/1 "2025-02-07T13:52:06Z")

</div>

The column has the type “Single select”. Sorting “A-Z” is available. The result is like this. How to sort the column correctly? So that it is in order 1,2,3 and so on…

 ![1](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/995b1d24cf521b7477cb4954499863362b51d670.png)

---

<div class="post-metadata">

### Author: ![mertmit](https://avatars.discourse-cdn.com/v4/letter/m/dc4da7/32.png) [@mertmit](https://community.nocodb.com/u/mertmit)
#### Post date: [February 7, 2025, 1:56pm UTC](https://community.nocodb.com/t/sorting-works-strangely/1649/2 "2025-02-07T13:56:22Z")

</div>

This is proper text order (see ordering on your filesystem for example) if you would like to get ascending or descending number order you need to use a numeric column.  
There is no way to know if you will have a mix of string and numerics within a single select.