Re: Performing a Range Comparison

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hello Rob,

I acheive this with wildcards. To find dates in a range 5 jan 2006 - 21 jan 2006, I have added formated tokens for the dates as follows Dyyyymmdd

so I look for (D20060105 or D20060106 or D20060107 or D20060108 or D20060109 or "D2006011*" or D20060120 or D20060121)


Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons


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


.

Relevant Pages