for some reason the following is not working properly:
I have a group of numbers (separated by comma) in a field that I would like to use.
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, 2506
I tried SELECT * FROM coa WHERE acctno IN (relatedaccts)
then: WHERE acctno IN (2206, 2306, 2406, 2506)
returns false: It does not find the 2306 in the IN clause. Or for that matter the 2406 or 2506
But it will find 2206.
Weird...
Any ideas or help...?