Thank you so much for your help. I was able to get the desired data.

Sean Lange (11/1/2012)

---

SQL_path (11/1/2012)

---

Gurus,

A quick q how do you enable search like this below . It returned nothing for me.

I was using set Replace(@search,'%','[%]') with my first code...

Gurus,

A quick q how do you enable search like this below . It returned nothing for me.

I was using set Replace(@search,'%','[%]') with my first code %+@search+% before.

now with...

thank you a tonn. this forum rocks !! 🙂

thank you Sean, I will try that and will come back to you.

thank you !!

i tried that but it did not work. can you please tell me what am I missing here?

declare @search varchar(max)

select @search='%cake'

create table #ITEM

(

item_desc varchar(50) )

INSERT...

[/quote]

I think at this point you need to provide all the details. ddl and sample data for all the tables. What you are saying doesn't seem to match up with...

Sean Lange (9/28/2012)

---

Can you post the actual values for your string and the EXACT error message. I don't see anything that would cause an error but I don't really know...

Sean Lange (9/28/2012)

---

Not enough details to provide much of an answer. What is in @orders? What does the split function look like?

I would recommend using the splitter found in...

thanks both of you !!

I ran a trace and it ran once.

[/quote]

Start by posting the Header (the CREATE PROC name and parameters followed by "AS"). That's where the problem probably is anyway.

[/quote]

Thank you Barry !! That was it.

Thanks for the reply. It is actually very long complicated code. I am trying to condense it and will try to post more without violating the policy ...sigh!!

thanks for reply . I am trying to insert chart in table. not sure how to do it?

Thank you all.

thank you.