I’m using the latest eXtreme 9.5 (64) and I’ve got a question for the SQL gurus. Here’s some sample data:
A table has 2 columns, customerID and CustName CustomerID CustName 1 ABC 123 2 ABC 234 3 ABC 345 4 DEF 123 5 DEF 234 6 GHI 123 7 GHI 234 Is there a SQL Update command (or other command) that will change the ‘ABC’ portion of the column CustName to ‘XYZ’, the results would be: CustomerID CustName 1 XYZ 123 2 XYZ 234 3 XYZ 345 4 DEF 123 5 DEF 234 6 GHI 123 7 GHI 234 I know I can do it with a snippet of code and a declare cursor but just wandering if there is a slick SQL command. TIA, Paul Buckley
