Text and numbers: transform without changing meaning

Build a product label and a small numeric measure. Text, search and rounding functions solve different tasks: changing case is not slicing, and a rounded number is not fixed-width decimal text.

A scalar function returns a new value per row. LENGTH measures length, SUBSTR extracts a segment and INSTR finds a position. ABS removes a sign; ROUND rounds a numeric value. Names and details differ between SQL engines.

Text and numbers: transform without changing meaning: A scalar function returns a new value per row. LENGTH measures length, SUBSTR extracts a segment and INSTR finds a position. ABS removes a sign; ROUND rounds a numeric value. Names and details differ between SQL engines.