>>> Kevin Waterson <[EMAIL PROTECTED]> 20/10/2003
>>>OK, that sounds fine, but is it possible to determine the type of field so my script will be able to add the quotes if it is of type INTEGER? >>>Kind regards Kevin, You can find the info you want in the sqlite_master table. There is some doco on it at the sqlite.org the website. I am not sure if the info is held anywhere else but select * from sqlite_master where name = quotes; will return the sql used to build the table. you can parse the data type from that. Regards IAN This message is intended for the addressee named and may contain confidential/privileged information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender, and are not necessarily the views of the Department. You should scan any attached files for viruses.