Sort (Order By) VARCHAR column contains Number in SQL Server

ayakamac...

Hello there, can anyone help me out with this problem? How to Query this:

My Query Code:

SELECT TOP 1000 [WireID]
  ,[PadNo]
  ,[Pattern]
  ,[Tester]
FROM [WLSystem].[dbo].[TblR8Pure] ORDER BY LEN(Tester), Tester ASC
GO

ayakamac...

0 5

I also got the answer before I read your reply.

This is my Answer:

MyAnswer

Your Answer:

YourAnswer

Thank you so much for the effort ! =)

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html