I have a group of numbers (separated by spaces) in a field that I would like to access.

I know what acctno is beforehand. Let's say it is 2306.

Lets say that I have the following in the relatedaccts column for the coa table:2206 2306 2406

I tried SELECT * FROM coa WHERE acctno IN (relatedaccts)

I received no errors but I did not get any results either.

Is there a way to do this?


Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."