MS-SQL Scalar functions

SQL Server scalar function takes one or more parameters and returns a single value.

• Upper() - Converts a field to upper case
• Lower() - Converts a field to lower case
• LEN() - Returns the length of a text field
• ROUND() - Rounds a numeric field to the number of decimals specified
Select upper(column_name) from table_name;
Select lower(column_name) from table_name;
Select substring(column_name,start,length) as some_name from table_name;
Select len(column_name) from table_name;
Select productname, round(price,0) as roundedprice from products;