Sql Trim

SQL trim

Created By: chatGPT

In SQL, the TRIM function is used to remove unwanted characters (usually spaces) from the start and end of a string. The basic syntax of the TRIM function is as follows:

TRIM([character] FROM string)

If the character parameter is omitted, TRIM will remove spaces by default. Here are some examples of how to use the TRIM function in SQL:

SELECT TRIM('   Hello World   ');
-- Result: 'Hello World'

SELECT TRIM('x' FROM 'xxxHello Worldxxx');
-- Result: 'Hello World'

You can also use the LTRIM and RTRIM functions if you only want to remove spaces from the left or right side of the string, respectively. Here are examples of their usage:

SELECT LTRIM('   Hello World');
-- Result: 'Hello World'

SELECT RTRIM('Hello World   ');
-- Result: 'Hello World'

If you need to remove other characters, simply specify them in the TRIM function. For example, to remove leading and trailing asterisks (*) from a string, you can do the following:

SELECT TRIM('*' FROM '*Hello World*');
-- Result: 'Hello World'

Remember that different SQL databases may have slightly different implementations or additional options within their TRIM functions. Always refer to your specific database documentation for accurate syntax and functionality.

-- Example for PostgreSQL:
SELECT TRIM(BOTH ' ' FROM '   PostgreSQL   ');
-- Result: 'PostgreSQL'