Boost Your SQL Skills with Powerful Character Functions
SQL Character Function|Part 1| SUBSTR,INSTR,CONCAT,UPPER,LOWER,INITCAP
SQL functions are similar to SQL operators in that both manipulate data items and both return a result. SQL functions differ from SQL operators in the format in which they appear with their arguments. The SQL function format enables functions to operate with zero, one, or more arguments.
SQL functions are used exclusively with SQL commands within SQL statements. There are two general types of SQL functions: single row (or scalar) functions and aggregate functions. These two types differ in the number of database rows on which they act. A single row function returns a value based on a single row in a query, whereas an aggregate function returns a value based on all the rows in a query.
Single row character functions accept character input and can return both character and number values.
