Hope, you could have a Parse function in your CLR type defined, which takes a string type as an parameter and in the function you split the string. Hope you...

Very insightful article!

Any idea if UDT/CLR types can be used?

Say I have AddressInfo User Defined Type and table like this:

CREATE TABLE [AddressBook](

[ID] [int] IDENTITY(1,1) NOT NULL,

[LastName] [varchar](25) NOT NULL,

[FirstName] [varchar](25)...