Question3Replies67Views×Close popoverSridhar Methukupally (SridharM4074) Scotiabank Scotiabank CA View Profile SridharM4074 Member since 2017 2 posts Scotiabank Posted: June 26, 2017Last activity: June 28, 2017Posted: 26 Jun 2017 17:04 EDTLast activity: 28 Jun 2017 12:14 EDT 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.9How 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.9I 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.×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 3 years agoPosted: 27 Jun 2017 4:59 EDT×Close popoverSwarnendu Mukherjee (SwarnenduM) Infosys Technology Architect Infosys AU View ProfileSwarnenduM Infosys replied to SridharM4074Hi Sridhar, Assuming you are doing it in Oracle DB, try to add RPAD with any value and make the entire string of fixed length. Then try to sort the result column keeping the entire query set in a sub query or view. Posted: 3 years agoPosted: 27 Jun 2017 11:47 EDT×Close popoverSridhar Methukupally (SridharM4074) Scotiabank Scotiabank CA View ProfileSridharM4074 Scotiabank replied to SridharM4074Thanks Swarnendu for the quick response , we are getting the data from REST connector, can you help on this Posted: 3 years agoPosted: 28 Jun 2017 12:14 EDT×Close popoverSwarnendu Mukherjee (SwarnenduM) Infosys Technology Architect Infosys AU View ProfileSwarnenduM Infosys replied to SridharM4074I think you can PAD retrieved the data in the data transform or activity followed by Obj-Sort. This is HL approach to share the idea and I haven't actually implemented this except in DB.