The question is
write a query to view the original string in customers.state, beside a modified version of customers.state where 'California' is replaced by 'CA'
I have no clue how to view the original and the modified beside one another
the best i cam eup with was
alter table customers
add state varchar
set customers.state = replace(state, 'CA', 'California');
I know it's incorrect
can anyone help me or guide me please?
thanks so much