esm

I have several Yes/No fields ( they are truely Yes/No with No being the defaul value ). What is the correct way to code the value in the table. Yes/No or 1/0?

thanks for helping me with this... take a look at my orignal post. the acctno is supplied to the select command which starts the loop thru the rows. I need to be able to select the row if the acctno exists in the relatedaccts column. thus the WHERE clause that read WHERE acctno IN (relatedaccts). which should work but doesn\'t. The IN clause should work if the values are as I have shown in the previous posts. the acctno is an integer type while the relatedaccts is a text type.

the problem with that is that relatedaccts changes from row to row as the select command loops thru the database. It may be 2007, 2008, 2009 for the first row but blank for the next row and 3049, 3061 for the third row, etc, etc.

thanks for the reply. However, I do need to use the relatedaccts field. SELECT * FROM coa WHERE acctno IN (relatedaccts) here is the abbreviated table structure for a row field type value acctno smallint-5 2006 desc test Accounts Payable amount float(6,2) -1347.49 relatedaccts text 2007, 2008, 2009

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...?