SQLTeam.com | Weblogs | Forums

Query to fetch record


#1

Hi

I have a query

I have 2 tables

table1(ocno [int],Productcategorycode [int])

table2(targetno [int],productcategorycodes [string]

field productcategorycodes is comma seperated

Now i want to write query fetching records matching Productcategorycode [int](first table)
with ,productcategorycodes [string](second table)

for exampe field productcategorycode value is '1'
Productcategorycodes value '1,2'

Query will display as oc123,1,targetno1,1

please help me

Thanks
Chandran