Continuing from the previous post
UPPER - Converts everything to capital, you can not use * to capitalize every column name as it will return an error (Ex. 1), therefore it is only possible to upper one column at a time.
LOWER - Is the opposite of lower, it ends up putting everything in lower case.
SUBSTRING - Substring checks inside a string of a column field which can then later be used in WHERE to compare if it has the specific characters, as seen in example 2 I was looking for 'wes'
REPLACE - Is used to take one value and replace it with another one, it should always be used in the SELECT area in order to be able to see it. (Examples 3 and 4) Allowing you to have some fun interactions, for example Jacksonbanana :)
LEN - Returns you the length of the value in a text, this can be used to find strings that are longer than a certain amount and return only them. (Example 5)
Returns all the sub-categories whose name has more than 8 characters. While the other bits in the query existed there to just spice it up, such as using year() to return year, month() to return month, and using aggregations for quantity.
ROUND - Is used to round numeric fields to the number of decimals specified. Examples 6 and 7
GETDATE - Think of it as a function which returns the current system date and time. Example 8 and 9
These are the scalar functions which are commonly used in SQL query. Thank you for reading.