How do I compare string?

Dear all,

How do I make a request such as list all the records from "ABC" to "DEF"?

Thanks

PlayKid

SELECT * FROM SomeTable WHERE SomeColumn >= 'ABC' AND SomeColumn <='DEF'

should be about right

In a SQL Statement?

Here's an example using Northwind:

SELECT * FROM dbo.Customers WHERE CompanyName between 'LA' and 'PR'