can i seperate values within one field?

[Anon]

I have a table named 'ISSUES'
I have a field in my table named 'PRODUCT_ID'

If i end up having more than 1 product, then multiple product ids get entered into this table seperated by a comma.

for example:
34,567,23

pull the name of each of these products based on another table named 'PRODUCT_INFO'

is there any way to query this field and pull the product name from PRODUCT_INFO for each product in 1 field without exploding it into an array and running another query?

[Anon]

Even if it is possible to do such a query it will be excruciatingly slow.

Your structure is all wrong. Put each productid as a separate record.

[Anon]

Hallo;

I hope it is better to redesign your Database as some body has commented. It is very nice to know that the value of each field in a given table is atomic i.e it contains only one value for each record.

May be you can break the table in to two tables and set relationship between them,

bye

[mikeq]

You should redesign the database, this breaks even First Normal Form.