Learn Common Functions in MS SQL Server By Doing | Interactive Course | Vertabelo Academy

Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

28/30 Exercise 2

1. Introduction

2. The Copywriter table

3. The Slogan table

4. The concatenation (+) operator

5. The CONCAT() function

6. The CONCAT() function vs. the + operator

7. The CONCAT_WS() functions

8. The LEN() function

9. Practicing LEN()

10. The DATALENGTH() function

11. The LOWER() and UPPER() functions

12. The LTRIM() and RTRIM() functions

13. The TRIM() function

14. The TRIM() function with characters

15. Text patterns: % and _

16. Text patterns: [ ]

17. Text functions - practice time!

18. The SUBSTRING() function

19. The LEFT() and RIGHT() functions

20. The CHARINDEX() function

21. The REVERSE() function

22. The REPLACE() function

23. The TRANSLATE() function

24. The STUFF() function

25. The REPLICATE() function

30. Congratulations

Okay, now try exercise number two!

For each slogan with a text longer than 20 characters, show a 20-character text fragment starting from the fifth position. Name the column SubText.

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings.You can modify your browser settings on your own. For more information see our Privacy Policy.