What is string manipulation in SQL?

< 1 min read

String manipulation in SQL means modifying or extracting text data using functions.
We can concatenate columns using || or CONCAT() for full names.
In my project, first name and last name were merged into Full Name.
We used SUBSTRING() to extract parts of a string, like area code from phone.
TRIM() removed extra spaces, and UPPER()/LOWER() standardized casing.
REPLACE() corrected typos or standardized abbreviations in product names.
LEFT() or RIGHT() helped extract fixed-length text portions.
These operations cleaned and prepared text data at source.
It reduces Power Query transformations and improves extraction efficiency.
So string manipulation ensures consistent and usable textual data for analysis.

Power BI Essentials