Re: my sql text query

>Nope, you change the field to not null then it won't allow null values in >the database. Since the data already has null values, the Alter Table would >probably fail. I should have been clearer - change the text field to non-null - this will cause the null entries to become empty strings (and hence your mysql_fetch_array calls will have an entry for that field containing an entry string) and then back again to null. I've just tried it on my machine and it works a treat. Cheers -- Phil Driscoll Dial Solutions +44 (0)113 294 5112 http://www.dialsolutions.com http://www.dtonline.org