fyi: sql server 2005 service packs and hot fixes

anyone using ssis ought to consider installing sp1 and the hot fixes.

of course, these should be tested before installing on a server in production.

Also, July update for Books Online is very useful http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en -

functions DIFFERENCE() and SOUNDEX()

Hi!
Is there any other function that can compares two strings ? I'm using the
functions DIFFERENCE() and SOUNDEX(), but they don't consider vowels, "y" and
"h", and I need something that compares everything!
thanks
--
Message posted via http://www.sqlmonster.comOn Fri, 09 Sep 2005 15:37:43 GMT, Amaury Coria via SQLMonster.com wrote:
>Hi!
>Is there any other function that can compares two strings ? I'm using the
>functions DIFFERENCE() and SOUNDEX(), but they don't consider vowels, "y" and
>"h", and I need something that compares everything!
>thanks
Hi Amaury,
What exactly do you mean with "compares everything"? If you are looking
for completely equal strings, just use the '=' operator. The SOUNDEX and
DIFFERENCE functions are deliberately leaving out certain parts of the
string, since they are intended to find common misspelling of words or
names. And in case you and/or your users are not English, beware that
they are designed for English.
If you want to find ""almost equal" strings but are not satisfied with
the algorithm used in SOUNDEX and DIFFERENCE, you'll have to create your
own functions for it. I have no experience with this kind of string
handling, but I believe that several algorithms for this kind of task
are out there on the internet. Google is your friend!
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||There's an interesting article about alternative (better) soundex-like
schemes at http://www.avotaynu.com/soundex.html.
Paul Shapiro
"Amaury Coria via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:541CE9D86DFA7@.SQLMonster.com...
> Is there any other function that can compares two strings ? I'm using the
> functions DIFFERENCE() and SOUNDEX(), but they don't consider vowels, "y"
> and
> "h", and I need something that compares everything!

functions DIFFERENCE() and SOUNDEX()

Hi!
Is there any other function that can compares two strings ? I'm using the
functions DIFFERENCE() and SOUNDEX(), but they don't consider vowels, "y" an
d
"h", and I need something that compares everything!
thanks
Message posted via http://www.droptable.comOn Fri, 09 Sep 2005 15:37:43 GMT, Amaury Coria via droptable.com wrote:

>Hi!
>Is there any other function that can compares two strings ? I'm using the
>functions DIFFERENCE() and SOUNDEX(), but they don't consider vowels, "y" a
nd
>"h", and I need something that compares everything!
>thanks
Hi Amaury,
What exactly do you mean with "compares everything"? If you are looking
for completely equal strings, just use the '=' operator. The SOUNDEX and
DIFFERENCE functions are deliberately leaving out certain parts of the
string, since they are intended to find common misspelling of words or
names. And in case you and/or your users are not English, beware that
they are designed for English.
If you want to find ""almost equal" strings but are not satisfied with
the algorithm used in SOUNDEX and DIFFERENCE, you'll have to create your
own functions for it. I have no experience with this kind of string
handling, but I believe that several algorithms for this kind of task
are out there on the internet. Google is your friend!
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||There's an interesting article about alternative (better) soundex-like
schemes at http://www.avotaynu.com/soundex.html.
Paul Shapiro
"Amaury Coria via droptable.com" <forum@.droptable.com> wrote in message
news:541CE9D86DFA7@.droptable.com...
> Is there any other function that can compares two strings ? I'm using the
> functions DIFFERENCE() and SOUNDEX(), but they don't consider vowels, "y"
> and
> "h", and I need something that compares everything!

functions DIFFERENCE() and SOUNDEX()

Hi!
Is there any other function that can compares two strings ? I'm using the
functions DIFFERENCE() and SOUNDEX(), but they don't consider vowels, "y" and
"h", and I need something that compares everything!
thanks
Message posted via http://www.droptable.com
On Fri, 09 Sep 2005 15:37:43 GMT, Amaury Coria via droptable.com wrote:

>Hi!
>Is there any other function that can compares two strings ? I'm using the
>functions DIFFERENCE() and SOUNDEX(), but they don't consider vowels, "y" and
>"h", and I need something that compares everything!
>thanks
Hi Amaury,
What exactly do you mean with "compares everything"? If you are looking
for completely equal strings, just use the '=' operator. The SOUNDEX and
DIFFERENCE functions are deliberately leaving out certain parts of the
string, since they are intended to find common misspelling of words or
names. And in case you and/or your users are not English, beware that
they are designed for English.
If you want to find ""almost equal" strings but are not satisfied with
the algorithm used in SOUNDEX and DIFFERENCE, you'll have to create your
own functions for it. I have no experience with this kind of string
handling, but I believe that several algorithms for this kind of task
are out there on the internet. Google is your friend!
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||There's an interesting article about alternative (better) soundex-like
schemes at http://www.avotaynu.com/soundex.html.
Paul Shapiro
"Amaury Coria via droptable.com" <forum@.droptable.com> wrote in message
news:541CE9D86DFA7@.droptable.com...
> Is there any other function that can compares two strings ? I'm using the
> functions DIFFERENCE() and SOUNDEX(), but they don't consider vowels, "y"
> and
> "h", and I need something that compares everything!

Full-text search

I am working as a sr. Developer for one of the application.
The search should allow to use whild cards....
Consider that I have three rows in table
1. Mark
2. Marketing
3. LandMark
When I search using contains and "Mark*" phrase it will return
Mark and Marketing
When I search using contains and "*Mark*" phrase I expect it to return all
rows but I am getting the same result as "Mark*"
It seems that
full text search does not work for postfix terms....
e.g. if user specifies 'Mark' as keyword the search should match 'Mark',
'Marketing' and 'Landmark'... right now the CONTAINS clause ignores the
'LandMark'
The leading * is thrown away in a search, the trailing on is treated as wild
card character.
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
"Raj Gandhi" <RajGandhi@.discussions.microsoft.com> wrote in message
news:D0334F24-F6F3-4909-A327-9E212D8AE376@.microsoft.com...
>I am working as a sr. Developer for one of the application.
> The search should allow to use whild cards....
> Consider that I have three rows in table
> 1. Mark
> 2. Marketing
> 3. LandMark
> When I search using contains and "Mark*" phrase it will return
> Mark and Marketing
> When I search using contains and "*Mark*" phrase I expect it to return all
> rows but I am getting the same result as "Mark*"
> It seems that
> full text search does not work for postfix terms....
> e.g. if user specifies 'Mark' as keyword the search should match 'Mark',
> 'Marketing' and 'Landmark'... right now the CONTAINS clause ignores the
> 'LandMark'

Full-text search

I am working as a sr. Developer for one of the application.
The search should allow to use whild cards....
Consider that I have three rows in table
1. Mark
2. Marketing
3. LandMark
When I search using contains and "Mark*" phrase it will return
Mark and Marketing
When I search using contains and "*Mark*" phrase I expect it to return all
rows but I am getting the same result as "Mark*"
It seems that
full text search does not work for postfix terms....
e.g. if user specifies 'Mark' as keyword the search should match 'Mark',
'Marketing' and 'Landmark'... right now the CONTAINS clause ignores the
'LandMark'The leading * is thrown away in a search, the trailing on is treated as wild
card character.
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
"Raj Gandhi" <RajGandhi@.discussions.microsoft.com> wrote in message
news:D0334F24-F6F3-4909-A327-9E212D8AE376@.microsoft.com...
>I am working as a sr. Developer for one of the application.
> The search should allow to use whild cards....
> Consider that I have three rows in table
> 1. Mark
> 2. Marketing
> 3. LandMark
> When I search using contains and "Mark*" phrase it will return
> Mark and Marketing
> When I search using contains and "*Mark*" phrase I expect it to return all
> rows but I am getting the same result as "Mark*"
> It seems that
> full text search does not work for postfix terms....
> e.g. if user specifies 'Mark' as keyword the search should match 'Mark',
> 'Marketing' and 'Landmark'... right now the CONTAINS clause ignores the
> 'LandMark'

Full-text search

I am working as a sr. Developer for one of the application.
The search should allow to use whild cards....
Consider that I have three rows in table
1. Mark
2. Marketing
3. LandMark
When I search using contains and "Mark*" phrase it will return
Mark and Marketing
When I search using contains and "*Mark*" phrase I expect it to return all
rows but I am getting the same result as "Mark*"
It seems that
full text search does not work for postfix terms....
e.g. if user specifies 'Mark' as keyword the search should match 'Mark',
'Marketing' and 'Landmark'... right now the CONTAINS clause ignores the
'LandMark'The leading * is thrown away in a search, the trailing on is treated as wild
card character.
--
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
"Raj Gandhi" <RajGandhi@.discussions.microsoft.com> wrote in message
news:D0334F24-F6F3-4909-A327-9E212D8AE376@.microsoft.com...
>I am working as a sr. Developer for one of the application.
> The search should allow to use whild cards....
> Consider that I have three rows in table
> 1. Mark
> 2. Marketing
> 3. LandMark
> When I search using contains and "Mark*" phrase it will return
> Mark and Marketing
> When I search using contains and "*Mark*" phrase I expect it to return all
> rows but I am getting the same result as "Mark*"
> It seems that
> full text search does not work for postfix terms....
> e.g. if user specifies 'Mark' as keyword the search should match 'Mark',
> 'Marketing' and 'Landmark'... right now the CONTAINS clause ignores the
> 'LandMark'