Hi Jeff, thanks for your interest. Ok, you asked for it so here goes...

Some background info first. We have an ASP.NET Web Application that serves up a list...

Hi Jeff, Whoa - you go dude!! That's pretty intense.

It is my intention to create a function for this in addition to some additional code.

I prefer not to use...

Call off the Dogs!!! Never mind. I figured it out myself.

DECLARE @String1 VARCHAR(100)

SET @String1 = 'Smith, Alex'

DECLARE @String2 VARCHAR(100)

SET @String2 = 'Smith, Alice'

-- Compare arrays one character at...

We have an ASP.NET Web Application that configures an Access Control System.

Key Holders (Last Names) are presented in a dynamic tree where nodes are generated on the fly.

If a request...

Alllright!! Works great.

Thanks, did you have to make it look so easy?

Great, works as advertised - well done. Now I need a slight tweak, sorry.

What I now need in the result set is slightly different

Very first last name, Nth last...