var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Using greater than within an update statement
I created this unique codes and
I need all [FRMDAT] field set to ‘12/31/2014’ in the MKLOPT table, where the [JOBCOD] in the VALUE list BELOW have a [FRMDAT] that is currently (greater than) > ‘12/31/2014’
SET FRMDAT = '12/31/2014'
WHERE (FRMDAT > '12/31/2014' AND JOBCOD IN ( PH03994, .......))
Run the bottom SQL first to see if you get your desired results.
//*Test with a select first before update. *//
SELECT JOBCOD, FRMDAT
WHERE (FRMDAT > '12/31/2014' AND JOBCOD IN ( PH03994, .......))]
Tags for this Thread