Q&A about the site for linguists, teachers and students of the Ukrainian language
declare @tbl as table(SalesOrderNo varchar(10)); insert into @tbl values ('1'), ('2'), ('D1'), ('D2'), ('D11'), ('D12'), ('D16'), ('D20'), ('D21'); select SalesOrderNo from @tbl where SalesOrderNo LIKE 'D%' and cast(right(SalesOrderNo, len(SalesOrderNo) - 1) as int) > 16;