Skip to content

trim.md

Latest commit

 

History

History
80 lines (50 loc) · 1.69 KB

trim.md

File metadata and controls

80 lines (50 loc) · 1.69 KB

📚 TRIM

The TRIM function is used in SQL to remove unwanted spaces (or other characters) from the beginning and end of a string.
It is helpful for cleaning up messy or inconsistent data.

🛠️ Basic Syntax

SELECT TRIM(column_name)
FROM table_name;
  • TRIM removes leading and trailing spaces by default.
  • Some databases allow you to specify which characters to trim.

Example

SELECT TRIM(first_name) AS cleaned_first_name
FROM employees;
  • This query removes any extra spaces at the start or end of each employee's first name.

Key Points

  • In MySQL and PostgreSQL, you can trim specific characters using TRIM('x' FROM column_name).
  • SQL Server uses LTRIM() for leading spaces and RTRIM() for trailing spaces separately.
  • Cleaning data before comparisons or reports can prevent hidden errors.

Additional Example

SELECT TRIM('   Hello World   ') AS trimmed_text;
  • This query returns 'Hello World' without the extra spaces.

🎥 Video Notes

📝 Problem Description

Describe the problem, challenge, or topic discussed in a video related to SELECT FROM.
What concept was explained or what exercise was solved?

DataBase Given

💻 My SQL Code

-- Write your SQL code attempt or solution related to SQL COMMAND
SQL COMMAND

🧠 Solution Code / Explanation

SQL COMMAND

Explanation - Explain what you learned, any key takeaways, or how you solved the problem related to COMMAND._

⬅️ Previous: CHARINDEX or SUBSTRING_INDEX Next ➡️ LEFT & RIGHT