RESULT:<\/strong> From the above result we can see that the LTRIM function is removing only the leading spaces. That is it has removed only the leading 4 spaces and not the trailing 4 spaces.<\/p>\n RTRIM function removes the trailing spaces from the input string<\/p>\n RESULT:<\/strong> From the above result we can see that the RTRIM function is removing only the trailing spaces. That is it has removed only the trailing 4 spaces and not the leading 4 spaces.<\/p>\n To remove the leading and trailing spaces we can nest the above LTRIM and RTRIM functions as shown in the below example:<\/p>\n RESULT:<\/strong> From the above result we can see that the nested use of RTRIM and LTRIM functions has removed both the leading and trailing paces.. That is it has removed both the leading 4 spaces and the trailing 4 spaces from the input string.<\/p>\n We can create a user defined function like the below one. And use it wherever we want to remove both leading and trailing spaces.<\/p>\n Below example shows how we can use the above created user defined TRIM function:<\/p>\n RESULT:<\/strong> Many a times we come across a scenario where we get an input string with leading and\/or trailing spaces. In such scenarios we would like to store it into the database by removing the leading and trailing spaces. But Microsoft doesn’t have a built-in TRIM function which can remove both leading and Trailing spaces. Instead … Continue reading TRIM function in Sql Server<\/span>
\n![\"ltrim-in-sql-server\"](\"https:\/\/sqlhints.com\/wp-content\/uploads\/2016\/09\/LTRIM-in-Sql-Server.jpg\")
<\/a><\/p>\n[ALSO READ] Difference between Len() and Datalength() functions in Sql Server<\/a> <\/h3>\n
RTRIM Function<\/h3>\n
\r\nDECLARE @StringToTrim VARCHAR(100) = ' String to trim '\r\nSELECT @StringToTrim 'String To Trim', \r\n\t DATALENGTH(@StringToTrim) 'Length of the string',\r\n\t RTRIM(@StringToTrim) 'String trimmed by RTRIM', \r\n\t DATALENGTH(RTRIM(@StringToTrim)) 'Length of RTRIM string'<\/pre>\n
\n<\/a><\/p>\n[ALSO READ] Usage of Function on Index Column in WHERE Caluse Leads to Index\/Table Scan<\/a><\/h3>\n
TRIM Function<\/h3>\n
\r\nDECLARE @StringToTrim VARCHAR(100) = ' String to trim '\r\nSELECT @StringToTrim 'String To Trim', \r\n DATALENGTH(@StringToTrim) 'Length of the string',\r\n RTRIM(LTRIM(@StringToTrim)) 'String trimmed by LTRIM and RTRIM', \r\n DATALENGTH(RTRIM(LTRIM(@StringToTrim)))\r\n AS 'Length of trimmed string'\r\n<\/pre>\n
\n<\/a><\/p>\n\r\nCREATE\tFUNCTION dbo.TRIM(@StringToTrim VARCHAR(MAX))\r\nRETURNS\tVARCHAR(MAX)\r\nBEGIN \r\n\tRETURN\tRTRIM(LTRIM(@StringToTrim))\r\nEND\r\n<\/pre>\n
\r\nDECLARE @StringToTrim VARCHAR(100) = ' String to trim '\r\nSELECT dbo.TRIM( @StringToTrim ) 'Trimmed string',\r\n DATALENGTH(dbo.TRIM( @StringToTrim )) \r\n AS 'Length of trimmed string'\r\n<\/pre>\n
\n<\/a><\/p>\n[ALSO READ] 100 Frequently used queries in Sql Server \u2013 Part 1<\/a><\/h3>\n","protected":false},"excerpt":{"rendered":"