Performing a Range Comparison

I want to index an address field so that I can do something like this:

Select * from Table where Address between '400 main street' and '5600 Main
Street'

Is this possible w/ FTS or any SQL Server products?

Thanks in Advance

--
Rob Schieber


.