Thank you both mrpolecat and Vladan.

What you share with me works.

It is unfortunate that the "database" is not normalized.  I am working on a web interface for a group of...

Thank you Ray for replying.  I am trying to avoid to code too many column names ( a total of 16) so I am going with Jason's method.

Thanks, Jason.  It works and does exactly what I want.  As you said, it is a challenge for me to figure out how it works.  I am taking it one...

This blog http://codebetter.com/blogs/brendan.tompkins/archive/2003/12/19/4746.aspx will throw some light on your concatenation question.

The list of user names comes from 'managers'.  These managers have a set of users/clients that they want to receive feedback from.  They especially know their users/clients by name not by PERSON...

Kudos, Bkelly.  You raised a problem that I did encounter.  I did have multiple people by the same first and last names or even people whose First Name is for...

Thanks, Michaela.  Is there a way to  the entire output to a text file instead of echo for each person?

What does the database collation apply to?

(only to the "DATA" in the database?) and not the database objects?  It seems to me that with a case insensitive collation at the...

Thank you both, Yada and Ray.  Works wonderfully.

Link to a script to view all triggers

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1019

wjwGeorgia,

You can take a look at http://vyaskn.tripod.com/searching_date_time_values.htm

Thanks, Minh.  It does drop the time portion but now the date is in fixed format (ie has the unnecessary leading zeros in the month and day).  And a character...

Thanks to both people who responded.  I found this link http://groups.google.com/group/microsoft.public.sqlserver.programming/msg/2d85bf366dd9e73e and it depicted 5 ways of doing what I am trying to do. One of which is the UDF...

Thanks, Amit.  I will give it a try.

Thanks for the pointer.  My table is a temporary table and I believe we cannot access temporary tables

from within a function. 

I will try to see if I can...