passing string as parameter to stored procedure sql2000

[ritu4321]

i want to pass and(SafetyCases.Link Like '%DL.125%' or SafetyCases.Link Like '%DL.233%' or SafetyCases.Link Like '%DL.256%' or SafetyCases.Link Like '%DL.259%' or SafetyCases.Link Like '%DL.288%' or SafetyCases.Link Like '%DL.518%' or SafetyCases.Link Like '%DL.534%' or SafetyCases.Link Like '%DL.538%' or SafetyCases.Link Like '%DL.67%' or SafetyCases.Link Like '%DL.68%' or SafetyCases.Link Like '%DL.683%' or SafetyCases.Link Like '%DL.777%' or SafetyCases.Link Like '%DL.800%') as parameter to my stored procedure can i do and how ?

[Ashfield]

Yes, the same as any other nvarchar parameter. create proc xyx (@parm nvarchar(4000)) as .... exec xyz @parm='.....'

Bob Ashfield Consultants Ltd