0

Please login or register to vote for this query.

(click on this box to dismiss)

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;

fork query

edited aug 5 20

created jun 15 16 anonymous