Table 1
839
739
837
736
737
Add 135 in front of the table 1
135839
135739
135837
135736
135737

CodePudding user response:

Select the when then

CodePudding user response:

Select '123' + ltrim (col_name) from x

CodePudding user response:

Select concat (' 123 ', col_name) from XXX.

CodePudding user response:

The select col=case
Then the when condition 1 COL='01' + COL
2 then the when condition COL='02' + COL
3 then the when condition COL='03' + COL
.
End
The from table1