Alpha numeric sorting in sql
708890Jun 25 2009 — edited Sep 16 2009Please help me in sorting the following data of a column in ascending or descending order :
Data
0B001.c
0B001.c.1
0B001.c.10
0B001.c.11
0B001.c.11.a
0B001.c.11.b
0B001.c.11.c
0B001.c.11.d
0B001.c.12
0B001.c.13
0B001.c.2
0B001.c.3
0B001.c.3.a
0B001.c.3.b
0B001.c.3.c
0B001.c.4
0B001.c.5
0B001.c.6
0B001.c.6.a
0B001.c.6.b
0B001.c.6.c
0B001.c.7
0B001.c.7.a
0B001.c.7.b
0B001.c.7.c
0B001.c.8
0B001.c.8.a
0B001.c.8.b
0B001.c.8.c
0B001.c.9
0B001.d
0B001.d.1
0B001.d.2
0B001.d.3
expected order:
0B001.c
0B001.c.1
0B001.c.2
0B001.c.3
0B001.c.3.a
0B001.c.3.b
0B001.c.3.c
0B001.c.4
0B001.c.5
0B001.c.6
0B001.c.6.a
0B001.c.6.b
0B001.c.6.c
0B001.c.7
0B001.c.7.a
0B001.c.7.b
0B001.c.7.c
0B001.c.8
0B001.c.8.a
0B001.c.8.b
0B001.c.8.c
0B001.c.9
0B001.c.10
0B001.c.11
0B001.c.11.a
0B001.c.11.b
0B001.c.11.c
0B001.c.11.d
0B001.c.12
0B001.c.13
0B001.d
0B001.d.1
0B001.d.2
0B001.d.3
Thanks,
Chandra