Re: testing if a field exist

Sean Kelsey wrote: > As for decision making in SQL - pretty tricky...Do you have SQL development > ?? If you do then you can write an ACE report to do the necessary "ALTER > TABLE" statements, otherwise you may need to spend some time writing fancy > shell scripts. The easy way: Run the ALTER TABLE statement. If it works, the field didn't exist. If it doesn't, it did. June -- june_t@hotmail.com Grounded in Palo Alto, living on chocolate chip cookies