|
Comments
|
|
Handy function to know about, can see a lot of usage for it
|
|
|
thank you. its new and very useful.
|
|
Jamshid Nouri on
11/3/2010
well done
|
|
|
Good video to Learn something new.
|
|
|
Nice!
|
|
|
Excellent
|
|
|
I like the mention of having the SOUNDEX column as a computed column that is indexed. Good suggestion.
|
|
|
Very impressive, everyday you learn something!!!
|
|
Steve Harris on
11/4/2010
Good examples.
|
|
|
great video
|
|
|
Very cool! Thanks Andy!
|
|
|
Good explanation of these functions!
|
|
|
very interesting
|
|
|
yet more functions that I don't use but I'm glad that you explained their use and drawbacks anyways. I always like your presentations because they are easy to understand and concise.
|
|
|
You should mention that soundex does not work well if there is a number in a string such as US101 and US20. I think soundex would consider those the same.
|
|
|
Great closing tip!
|
|
|
would have been a 5, but you glossed over making the soundex query a computed column to avoid something- the extra 15 seconds to explain and show an example would have made it perfect.
|
|
Sara Karasik on
11/4/2010
Excellent, as all of Andy's are!
|
|
|
very good tip. Never heard of soundex before. Have to give it a try some time.
|
|
|
cool
|
|
Calvin Jones on
11/4/2010
Does using SOUNDEX on a column prevent the optimizer from using an index on the column?
|
|
|
Nice Job
|
|
|
Great to know!
|
|
|
thanks, i learned something totally new from this.
|
|
|
Is soundex also available for other langauages than English?
|