Question

3
Replies
66
Views
SridharM4074 Member since 2017 2 posts
Scotiabank
Posted: 3 years ago
Last activity: 3 years 3 months ago
Closed

How to sort a varchar as a numeric? Example: 1.2.1, 1.2.10,1.2.11,1.2.2,1.2.3,1.2.4,1.2.5,1.2.6,1.2.7,1.2.8,1.2.9

How to sort a varchar as a numeric? Example: 1.2.1, 1.2.10,1.2.11,1.2.2,1.2.3,1.2.4,1.2.5,1.2.6,1.2.7,1.2.8,1.2.9

I am expecting the order as 1.2.1,1.2.2,1.2.3,1.2.4,1.2.5,1.2.6,1.2.7,1.2.8,1.2.9,1.2.10,1.2.11.

If anyone has encountered this issue and has a solution, please do let me know.

Moderation Team has archived post
Share this page LinkedIn