Re: Performing a Range Comparison

No, you would be able to pick up the main street, and then you would have to
extract the values and do a set based operation on them.

--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Rob Schieber" <nospam@xxxxxxxxxxx> wrote in message
news:ugWtDcbOHHA.960@xxxxxxxxxxxxxxxxxxxxxxx
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

  • Re: Full text Pattern Search
    ... "Hilary Cotter" wrote: ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ... Director of Text Mining and Database Strategy ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Install of SQL Server 2005 fails due to no space to extract pa
    ... Actually I am using sqleval.exe (180 day trial of the SQL server 2005). ... It went through the extracting package stage, ... location to extract to. ... tried to install that. ...
    (microsoft.public.sqlserver.setup)
  • Re: Near Clause usage
    ... NEAR clause using CONTAINS? ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ... get the exact words I m looking for within my NEAR clause: ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Merge Replication - sp_addscriptexec
    ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ... running osql not the account running the sql agent service. ...
    (microsoft.public.sqlserver.replication)
  • Re: Gatherer log
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... Looking for a SQL Server replication book? ... Looking for a FAQ on Indexing Services/SQL FTS ...
    (microsoft.public.sqlserver.fulltext)
Loading