Data in co_num column of customer table shows:

CQS0002509

CQS0002510

CQS0002511

cqs0002512

cqs0002513

cqs0002514

cqs0002515

CQS0002516

CQS0002517

CQS0002518

CQS0002519

CQS0002520

Tried the select statement as follows:

SELECT *

FROM co

WHERE co_num COLLATE SQL_Latin1_General_CP1_CS_AS like 'cqs%'

Results:

co_num

----------

cqs0002512

cqs0002513

cqs0002514

cqs0002515

which is exactly what I want 🙂

Now I need to fix the data using the following Update command

update co

set co_num = 'cqs0002515'

where co_num = 'CQS0002515'

Is there a way to update a group of records such as all "cqs%" to become "CQS%"?