Thanks, Farrell.  The reason that I stored multiple user IDs in one field was trying to save some database space since the form was really huge. I haven't received any...

Thank you all.  I used Noel's sample and it worked out fine.

can you be more specific, a sample syntax would be appreciated very much

thank you for everyone's help.  the query from fhanlon was indeed had some problems. 

I used the one provided by noeld and it worked fine.

It works now. thanks. I'm happy now

Here is my code:

########################################

Declare @MyMessage nvarchar (255)

Set @MyMessage = 'Sent out emails'

Declare MyCursor Cursor For

Select email From fs_users  Where user_id < 35

Open MyCursor

Fetch Next From MyCursor Into @MyRecipients

While...

it works well, thanks