I need to find if a field has a value of "key" then change that value to "1234567890'. Here is the statement
DECLARE @CHK CHAR(10)
SET @CHK = '1234567890'
SELECT DOCTYPE, VENDORID, DOCDATE, DOCNUMBR, DOCAMNT, CHEKBKID, VOIDED,
CASE WHEN CHEKBKID = 'KEY' THEN CHEKBKID = @CHK
WHERE DOCTYPE =6 AND DOCDATE = '4/19/2005' AND DOCNUMBR LIKE '0124%'