June 6, 2005 at 2:39 pm
Warning: I am new to SQL Server 2000. Excuse me for my ignorance.
I am trying to update some data in a table called "resource". I have a column "lot_ctl_item" where the value is "Y". I need to change the value to "N". I am using the "UPDATE" command, but no go. What am I missing. I realize my statement probably is not right.
update resource set lot_ctl_item = lot_ctl_item N where lot_ctl_item = Y
June 6, 2005 at 2:42 pm
update resource set lot_ctl_item = 'N' where lot_ctl_item = 'Y'
June 7, 2005 at 6:30 am
That's it. Thanks!
June 7, 2005 at 6:38 am
HTH.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply