Nice article, as always.  I would just point out that when you use a default value for an input parameter, you can actually leave the parameter out of the call if...

Hi Robert, Duray and Shewmaker -

I resolved the issues and have sent the updated files to the good guys here at SQLServerCentral.  Here's the fixes:

-NYSIIS multi-character encoding (i.e., "vowel...

Hi and thanks for the comments!

You're right, all vowels should be replaced with 'A', and adjacent vowels should be reduced to a single 'A' during the process.  I'll have a...

Thanks for the feedback.  Do you have some examples of that issue you can share?  A couple of strings that are returning different results dependent on the order?  One workaround...

If this is the case, what exactly is the advantage of creating a UDT in SQL Server and allowing access to it as opposed to just creating a Class in...

Who says there's nothing on the type but those properties?

We did.  Look at previous posts; these are the only properties and methods defined so far.

How do you know there aren't...

So, how exactly do we implement a DistanceFrom() operator without encoding our Addresses using a standard UOM?  (like lat/lon for instance)?  There is nothing intrinsic to this particular type, as...

Thanks for the feedback!  I'm glad you found it useful.  UDF's in the WHERE clause do tend to slow down your SELECT statements since they have to perform a row-by-row...

If you're using SP's to perform the actual INSERT (as I usually do), you probably would want to use SCOPE_IDENTITY inside the SP itself.  As for using a direct INSERT...

What's infeasible is performing scalar operations on it:

Address1 = "12 West Broadway, New York, NY 10036"

Address2 = "941 Market Street, San Francisco, CA 94109"

Address3 = Address1 + Address2

Address4 = Address1...

You're talking about scalar operations on simple/primitive UDT types.  In the example you are talking about a datatype called AddressLine which is composed of a single unit of data (a VARCHAR,...

Thanks for the feedback!  There is, of course, always more that can be added to most discussions   I've used the English Query Automation API...

I was thinking more along the lines of just declaring a variable, assigning the value and it automatically encrypts or encodes to the proper base.  You're right, there's probably not much...

There's a "compact" double-metaphone implementation over at The Code Project.

The problem is that we're de-normalizing the data using UDT's.  It also seems that all the kinks aren't worked out on the MS end yet.  It seems to me that...