SQL (Structured Query Language) offers a powerful suite of functions for data transformation, enabling users to manipulate and analyse data effectively. Based on the nature of their operation, these functions are classified into different types. The most commonly used categories are string, numeri