Visual Basic 6 Sp5
SQL Server 2000
--------------------------
i want to make sql select to select items between two words like

select * from items where itemno >=ab and itemno<= dr

itemno is nvarchar(15)

but these not give the correct values

Is there any way to solve these to be able to select between two letters or numbers value

Thanks