SQL (Structured Query Language) provides various string functions that allow you to manipulate and operate on string data. String data is used to represent and manipulate character-based information. String data types are fundamental components of databases, allowing the storage and retrieval of textual information.
Common string data types are:
- CHAR(n): Fixed-length character string. It always reserves a fixed amount of storage, padding with spaces if necessary.
- VARCHAR(n): Variable-length character string. It only stores the actual data, without padding.
- TEXT: Variable-length character string with a very large maximum length. Suitable for storing large amounts of text.
Note: The exact set of string functions can vary slightly depending on the database management system (DBMS) you are using, as different database systems may have their own unique functions or syntax.
I. STRING FUNCTIONS:
1. CONCAT(str1, str2, …):
Concatenates two or more strings.
SELECT CONCAT('Hello', ' ', 'World') AS Result;
-- Result: Hello World