Hope the following code will address your requirement if your table has a primary key.

DECLARE @Pkey int

SELECT @PKey = Table_Primary_Key FROM Your_Table_Name

WHERE COLA LIKE '%A' AND COLB IS NULL

UPDATE...