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

Now you know the basic text functions in SQL Server.

This time, we're going to focus on numeric functions. Click Next Exercise to start.

30/30 Congratulations

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

Excellent! You've completed all the exercises!

That's it for today. In the next part, you will learn some basic numeric functions. See you soon!

Click the Next exercise button to proceed to the next part.

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.