I've modified Lowell's function and performed a time-comparison test. Ihaven't thoroughly tested the function, since if it's too slow it won't be useful anyway. I used and input file of...

I work at a private college, but it's still politics to some degree. Even though my department head explained this to the cabinet, I'm not sure that they understand or...

I would love to purchase such a program. I have one in mind that is partnered with our vendor and would provide numerous benefits to our institution, but it's not...

That looks promising, Lowell. I'd need to add a piece for special letters like those with accents, umlauts, etc. I've used tally tables before, thanks to Jeff Moden's well-written article,...

Thanks for the suggestions.

While I don't dispute that CLR functions in C# are better, I am currently restricted to TSQL.

I tried using the soundex function and there were too...

Thanks, Lowell, that's helpful.

Julie

Steve, you scooped the New York Times! Well, this NYT blogger, anyway. http://well.blogs.nytimes.com/2010/05/17/time-to-review-workplace-reviews/?th&emc=th If you look at the comments, you can tell she struck a nerve. It makes me realize...

Thank you both for your responses.

Julie

I am not a DBA, nor do I aspire to be one. I do occasionally assist our sole DBA (he wears many hats). I'm a systems analyst and I have...

Hugo Kornelis (4/21/2010)

Go to the page referenced in the explanation of the question; scroll...

I like the idea of giving people some choices. I work in higher ed and this year for our "Years of Service" award we could chose from the standard gift...

Sorry, I misstated this. :blush: Because it's not ANSI-92 standard, it COULD be deprecated. For a comparison between ISNULL and COALESCE, see http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=ISNULL_COALESCE

Julie

I recommend that you use COALESCE. ISNULL is also due to...

I'm originally from Milwaukee, Wisconsin -- City of Bubblers, A great city on a Great Lake. I now live and work in NE Iowa. BTW, I love to say "I'm...

Me, too. I often learn more from the ensuing discussions.

Julie