On Wed, Sep 14, 2011 at 10:04 AM, Rich Shepard <rshepard@appl-ecosys.com> wrote:
> This found the appropriate rows. Now, my question is DDL-related:
>
> What is the appropriate syntax to change 'GW-22 +' to GW-22? Can I use
> 'like' or '~' in an ALTER TABLE RENAME <column> ... statement?
I'm confused. Do you want to UPDATE the affected records to GW-22. Or
do you want to ALTER the table to add a column constraint to prevent
malformed site_id's in the future?
--
Regards,
Richard Broersma Jr.