How is the trim function used in SQL?

2 years ago
William Carter
2 minutes

In SQL, the TRIM function is used to remove specified characters (default is whitespace) from the beginning and end of a string. Its usage is as follows:

Remove the specified character from the string.

The specified character is optional. If not provided, leading and trailing whitespace characters will be removed by default. If the specified character is provided, all characters contained in the specified character will be removed from the beginning and end of the string.

For example, here are some examples of using the TRIM function:

  1. Remove the spaces at the beginning and end of the string:
    SELECT TRIM(‘ hello ‘) AS trimmed_string;
  2. The result is ‘hello’.
  3. Remove specified characters from the beginning and end of a string – for example, commas and spaces.
    SELECT TRIM(‘, ‘ FROM ‘, hello, ‘) AS trimmed_string;
  4. The outcome is ‘hello’.
  5. Remove multiple specified characters from the beginning and end of a string:
    SELECT TRIM(‘., ‘ FROM ‘, hello. ‘) AS trimmed_string;
  6. The outcome is ‘hello’.

It is important to note that the TRIM function can only remove characters at the beginning and end of a string, and cannot remove characters in the middle of a string. If you need to remove characters in the middle of a string, you can use other string functions (such as the REPLACE function) to accomplish this.

bannerAds