update acadprod set referencia ='' 
where 
(referencia like '%A%') or
(referencia like '%B%') or
(referencia like '%C%') or
(referencia like '%D%') or
(referencia like '%E%') or
(referencia like '%F%') or
(referencia like '%G%') or
(referencia like '%H%') or
(referencia like '%I%') or
(referencia like '%J%') or
(referencia like '%K%') or
(referencia like '%L%') or
(referencia like '%M%') or
(referencia like '%N%') or
(referencia like '%O%') or
(referencia like '%P%') or
(referencia like '%Q%') or
(referencia like '%R%') or
(referencia like '%S%') or
(referencia like '%T%') or
(referencia like '%U%') or
(referencia like '%W%') or
(referencia like '%V%') or
(referencia like '%X%') or
(referencia like '%Y%') or
(referencia like '%Z%') or
(referencia like '%a%') or
(referencia like '%b%') or
(referencia like '%c%') or
(referencia like '%d%') or
(referencia like '%e%') or
(referencia like '%f%') or
(referencia like '%g%') or
(referencia like '%h%') or
(referencia like '%i%') or
(referencia like '%j%') or
(referencia like '%k%') or
(referencia like '%l%') or
(referencia like '%m%') or
(referencia like '%n%') or
(referencia like '%o%') or
(referencia like '%p%') or
(referencia like '%q%') or
(referencia like '%r%') or
(referencia like '%s%') or
(referencia like '%t%') or
(referencia like '%u%') or
(referencia like '%w%') or
(referencia like '%v%') or
(referencia like '%x%') or
(referencia like '%y%') or
(referencia like '%z%') or
(referencia like '%.%') or
(referencia like '%,%') or
(referencia like '%;%') or
(referencia like '%:%') or
(referencia like '%ç%') or
(referencia like '%Ç%') or
(referencia like '%/%') or
(referencia like '%\%') or
(referencia like '%-%') or
(referencia like '%{%') or
(referencia like '%}%') or
(referencia like '%[%') or 
(referencia like '%]%')
COMMIT WORK;