SQL Order By not working properly <p>I have a table like this</p> <pre><code> CREATE TABLE [dbo].[tbl_LandRigs]( [ID] [int] IDENTITY(700000,1) NOT NULL, [Company] [nvarchar](500) NULL, [Rig] [nvarchar](500) NULL, [RigType] [nvarchar](200) NULL, [DrawWorks] [nvarchar](500) NULL, [TopDrive] [nvarchar](200) NULL, [RotaryTable] [nvarchar](500) NULL, [MudPump] [nvarchar](500) NULL, [MaxDD] [nvarchar](50) NULL, [Operator] [nvarchar](500) NULL, [Country] [nvarchar](200) NULL, [Location] [nvarchar](500) NULL, [OPStatus] [nvarchar](200) NULL, [CreatedDate] [datetime] NULL, [CreatedByID] [int] NULL, [CreatedByName] [nvarchar](50) NULL, CONSTRAINT [PK_tbl_LandRigs] PRIMARY KEY CLUSTERED ( [ID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] </code></pre> <p>And I am trying to get data from MaxDD column in Descending order</p> <pre><code>SELECT distinct "MaxDD" FROM [tbl_LandRigs] ORDER BY "MaxDD" Desc </code></pre> <p>But this returns data in following order <img src="https://i.stack.imgur.com/J2mSM.png" alt="enter image description here"> According to my calculation 4000 must be the first value followed by others.But this results astonished me.Can any one help me out in this?</p>