search SQL statement

[knuckle05]

Hi All,

I need to perform a search on my DB and I am able to get exact matches like this:

Select * FROM myTable WHERE myField LIKE 'ABC*'

but now I need to return all records that fall between A-G, and then H-P and so on. Is there a way to search all records between those letters?

Can someone help me modify this SQL statement to allow me those results?

thx!!

 

[vidru]

A-G

SELECT * FROM myTable WHERE myField LIKE '[A-G]%'

H-P

SELECT * FROM myTable WHERE myField LIKE '[H-P]%'

Q-Z

SELECT * FROM myTable WHERE myField LIKE '[Q-Z]%'

Check out BOL (Books Online) for wildcard searches with the LIKE operator.

-dave