Hi Remi,

I just tried using like and it doesn't work. Can you take a quick look?

SELECT  @bag_nums= COALESCE(@bag_nums + ', ','') + CAST(bag_num AS VARCHAR(10))

FROM tblBag_data

WHERE     work_ord_num LIKE...

Hmmm but I'll duplicating the same data.  I'll look into how often will I need to extract the work_ord_num.  I do appreciate your suggestions. 

Have a great day!

Hi Remi,

Are you saying I should have a column for ID OR that work_ord_num should be in a separate column? 

I don't have have ID column in the table. The primary keys are consisted of...

VERY NICE.

Thank you Remi!

Thanks AJ & Remi for your replies.

I need to explain what the @bag_nums should return. I need bag # for ea record that meets the criteria and the bag #'s...

Yep, That's the problem. Thanks PW!

Thanks for your response.  after removing "exec" it took care the error message but it stilll won't allow me to pass in parameter.  I did figured out how I can...

Thanks, Frank!

I'll make a note of that.

Thanks!

Thank you! That works.

Another great idea.

Thanks Calvin!

Thanks Brian!

That helps alot.

Hi PW,

Thanks for your reply.

I have some 20 columns in the tblFinal_inspection.  Is that the only way to insert a duplicate record w/o inserting the identity column?

Thanks!

Hi Bill,

No, I ended up creating a stored procedure and UDF to encrypt and decrypt the password from a post I found.  This is what I'm using:

March 16, 2005 at 12:25 pm