Re: testing if a field exist

But won't the entire SQL script fall over ?? Error handling in SQL is... non-existent !! June Tong wrote in message <36707B9C.52585B51@hotmail.com>... >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 > >