Scott
Sent: Wednesday, 29 August 2007 11:51 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Query Help
Dale,
'% cheese %'
Seems to defeat the purpose of having a like, if you put spaces I would say
that the %'s are no longer needed.
Anyway I am still not sure what
SQL Server 2005
Regards
Dale Fraser
http://dalefraser.blogspot.com
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Charlie Arehart (lists account)
Sent: Thursday, 30 August 2007 8:12 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Query Help
Dale
I know you know it's not normalised, but why not normalise?
That aside, SQL Server doesn't seem to like to do too many LIKE queries,
in my experience. But as the others have suggested, you might want to
look into it's full text indexing capabilities.
Dale Fraser wrote:
I have a database
I agree with the others. Your problem is a text book example of what
normalising is for. Having tags represented in a separate table allows you
to find all the items with a specific tag or find all tags on a specific
item with one lightening quick select.
Blair
On 8/30/07, Haikal Saadh [EMAIL
] Re: Query Help
SQL Server 2005
Regards
Dale Fraser
http://dalefraser.blogspot.com
From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
Of Charlie Arehart (lists account)
Sent: Thursday, 30 August 2007 8:12 AM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Query
account)
Sent: Thursday, 30 August 2007 1:59 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: Query Help
OK, so have you considered looking into its text indexing features, based on
this discussion? :-)
/charlie
_
From: cfaussie@googlegroups.com [mailto:[EMAIL