Sql order by

[ayakamacy]

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

[AjayGohil]

Try this query for order by

SELECT * FROM ("Your table name")
ORDER BY ("Column name");