Exercise

# Calculating the length of a string

It is important to know how to calculate the length of the strings stored in a database. You may need to calculate the product with the shortest name or the person with the longest email address.

Calculating the length of a string also proves to be useful in data cleansing and validation tasks. For example, if a business rule is that all product codes must have at least 6 characters, you can easily find the ones that are shorter.

In SQL Server, you can use the `LEN()`

function for calculating the length of a string of characters.

You will use it in this exercise to calculate the location with the longest name from where cocoa beans are used (column `broad_bean_origin`

, from the `ratings`

table).

Instructions

**100 XP**

- Calculate the length of each
`broad_bean_origin`

. - Order the results from the longest to shortest.