Introduction
Concatenation
Simple text functions
How to modify Strings
Summary

## Instruction

Great! But what if you want to remove a set of characters from the beginning and end of a string? You can also use TRIM() to do that. This requires an additional argument: a string containing the characters you want to remove (the first argument) and the actual text (the second argument).

Let's remove the following characters from a sentence: ., ?,  , and !

SELECT TRIM(N' !?.' FROM N'?What is the best way to do it? !.');

Notice that this function contains a FROM between the list of characters to remove and the text.

This is the result you obtain:

N'What is the best way to do it'

As you can see, all specified characters were removed from the beginning and end of the text.

## Exercise

Remove all leading and trailing spaces and zeros from the item names in the Item table. Name the column After.

### Stuck? Here's a hint!

Use TRIM() with the folowing arguments: a string listing the characters to remove, FROM, and the column with the names.