SQL statement formatted number (preceded by 0), replacement string

The following is a detailed analysis:

1. Select Power (10,3) gets 1000 (i.e. 10 of 3 Parties)

2. Select CAST (1000+33 as varchar) converts the 1000 conversion type (i.e.: convert int to varchar type)

3. Select Right (100033,3) takes 3 characters from the left to get 033

Format 1 Ibid.

Select Right (CAST (power (10,3) as varchar) +33,3)

Replacement string (AAA replaced with BBB)

Update table Set [Column]=replace ([column], ' AAA ', ' BBB ')

SQL statement formatted number (preceded by 0), replacement string