Thanks. This now makes sense if I were to take a different approach.

Warm regards.

touchmeknot (2/7/2011)

---

Solution is kind of similar to that of Nate.

DECLARE @STR VARCHAR(50)

SET...

Dude, I feel like a little kid with a new toy!

This really helped. Thanks for your kind advise and suggestion on books. I have the following:

- Beginning...

Hey Vedran,

Your code really worked. I'm grateful for your help. Can you please explain some of your sample a little bit further? I have a few textbooks...

Hi,

I meant to say the number of days.

My original code is like the following:

use Students

SELECT StudentID As ID, StudentLFM As [Student Name],

(CASE WHEN ISNULL(MondayRequired,...

Hi Vedran,

Interesting suggestion. Sometimes I do use tallies, however, at the moment I simply need to list instances of people who have special days in their schedules. I...

Hi,

Programming is not and has never been my forte. I am not looking to create a database from scratch following the best parameters possible. I am working with...

RP_DBA (2/4/2011)

---

Change your string to start with the comma.

So instead of: 'Tuesday, Wednesday, '

It would be: ', Tuesday, Wednesday'

And then you're able to always cutoff the 1st two characters.

DECLARE

Thanks Nate!

I'll give it a try and let you know of the outcome.

jfmonteroso