Thanks for all the replys on the subject, I'd covered the above & got there in the end so many thanks...

Thanks...

Chris Morris-439714 (7/7/2010)

No it won't, not without modification.

Have you got backups of your data?

How important to you / your company is your data?

If you don't mind losing it forever...

Chris Morris-439714 (7/7/2010)

UPDATE MyTable SET [disabled] = MyNewValue

WHERE [date created] < 'June 2005'

Edit: This is a basic UPDATE statement, it doesn't get any easier - except you will have...

Sorry to drag an old thread back up to the top, however I...

That worked a treat! Thanks Chris & everyone else for there input 🙂

Cheers

OMD

That looks & appears to make more sense Chris 🙂

I'll give it a whirl.

Thanks

OMD

Hi,

I'm trying to add a value (that value being Y) to the same...

blue_inelush (6/21/2010)

---

Hello,

You need to change your script from:

INSERT INTO docsadm.shellorganisation (disabled) VALUES ('y');

WHERE (((docsadm.shellorganisation.org_name) like 'do not use%'));

to something like this:

Insert into docsadm.shellorganisation (disabled)

select 'y' -- what columns do...