jasonspopma
asked on
SQL Field Mass Update
SELECT custno, ldate, custstat
FROM arcust
"ldate" is last date of sale dates formatted like "6/6/2007 12:00:00 AM" The time is the same for all the dates.
"custstat" date is a "I" or "A". This field is for active or in-active.
I am looking to make all customer with a last date of sale of 12/31/11 or older have a status of "I"
FROM arcust
"ldate" is last date of sale dates formatted like "6/6/2007 12:00:00 AM" The time is the same for all the dates.
"custstat" date is a "I" or "A". This field is for active or in-active.
I am looking to make all customer with a last date of sale of 12/31/11 or older have a status of "I"
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As long as the time portion of every value in your column is represented as midnight, the above should do the trick.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.