CREATE TABLE my_error (wrong VARCHAR(50));

INSERT INTO my_error VALUES ('Addiction Advice Services Ltd.'); INSERT INTO my_error VALUES ('AIR BP_and-mistake'); INSERT INTO my_error VALUES ('AIR New Zealand Airlines');

SELECT * FROM my_error ORDER BY wrong;

WITH my_cte AS ( SELECT CASE WHEN UPPER(wrong) LIKE 'ADDICTION ADVICE%' THEN 'ADDICTION ADVICE' WHEN UPPER(wrong) LIKE 'AIR BP%' THEN 'AIR BP' WHEN UPPER(wrong) LIKE 'AIR NEW Z%' THEN 'AIR NEW ZEALAND' ELSE '****ERROR****' -- you may or may not need this! -- If converting every record, then yes, if not, then no! -- Errors should stand out on browsing and it's easy to search for! END AS wrong FROM my_error ) SELECT * FROM my_cte;