SQL Between

[shangrilla]

I am trying to get data where lastName falls between 2 values eg: A thru E. This would only give me data where lastNames are from A thru D.

I am using BETWEEN val1 and val2
Can I modify this statement or use something else to include lastNames starting with E also.

Thanks

 

[JohnDTampaBay]

Your criteria would return someone with a last name of only E. Its the letters than follow the E that are giving you grief. Try this:

BETWEEN val1 and val2+'Z'

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.