SQL Server: Built-In Functions

Description

Scalar functions are functions that return a single scalar value as output, unlike table-valued functions that return a whole table.

In this lab, you will be learning how to use Scaler (Built-In) Functions in SQL Server.

Based on this Customer and Supplier Schema, generate the solutions to the respective queries listed below:

1. List customers with lowercase names.
2. Remove the specified start and end characters (!, # and space) from the string.
3. List all products with the length of the product names.
4. List customers with first initials and last names.
5. List all products with a column that indicates bottle packaging.
6. List products and categorize them as cheap or expensive. Sort by product name.

Lab Objective

Upon completion of this lab, you will be able to:

• Gain Hands-On Experience on SQL Server Scaler Built-In.

Prerequisites

• You should have a conceptual understanding of Functions.
• You must have SQL Server Installed on your systems.