SQL Learning data column go to the whitespace function

1, LTRIM ()---Remove the space to the left of the column values as follows:

Select *  from where tno='t003' and CNO='c0013  '

We find that there is a space at the far left of the CNAME column value for this row of data, for the accuracy of the data, we now need to remove the space, here is the solution code:

Select LTRIM  from where tno='t003' and CNO='c0013  '

2, RTRIM ()---Remove the space to the right of the column value---function and ltrim (), no introduction here

3. replace (calculated field, ', ')---Remove all the spaces in the computed field column values, as follows:

Select  from where tno='t003' and CNO='c0013  '

Now there is a need to remove all the spaces in the CNAME field column values, and the following resolves the code:

Select Replace (CNAME,','from where tno='t003'   and CNO='c0013'

OK, all the blanks are gone, the demand is complete!

SQL Learning data column go to the whitespace function