indexing urls

Hi, I have a column on a table that store urls. I want to index this column.
But it seems that SQL Server is indexing the whole url and not each part of
it (domain, querystring, etc). So if I have this url
www.onedomain.com/somepage.aspx
And I query 'onedomain' I want to get that url. However I'm not getting it.
I think it's because it is indexing the whole url and not every part of it.
could you tell me how can I workaround this?
thanks
Matias
try indexing it using the neutral word breaker.
it works for me using SQL 2000 sp3, on win2k professional. sp4
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Matias Woloski" wrote:

> Hi, I have a column on a table that store urls. I want to index this column.
> But it seems that SQL Server is indexing the whole url and not each part of
> it (domain, querystring, etc). So if I have this url
> www.onedomain.com/somepage.aspx
> And I query 'onedomain' I want to get that url. However I'm not getting it.
> I think it's because it is indexing the whole url and not every part of it.
> could you tell me how can I workaround this?
> thanks
> Matias
>
>
|||Matias,
It will also work if you upgrade to Windows Server 2003 and you get to take
advantage of using US_English and still can use formsof(inflectional) which
is a function that you lose with the Neutral word breaker.
Regards,
John
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:5D3295FD-D6F7-4F2A-8721-9855FD3E0362@.microsoft.com...[vbcol=seagreen]
> try indexing it using the neutral word breaker.
> it works for me using SQL 2000 sp3, on win2k professional. sp4
> --
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
>
> "Matias Woloski" wrote:
column.[vbcol=seagreen]
of[vbcol=seagreen]
it.[vbcol=seagreen]
it.[vbcol=seagreen]
sql