Advanced Search

SQL Trim Function

/ Published in: SQL
Save to your folder(s)
Today I need Trim() function in sql, but in Sql 2005 there is no function. Because of that I wrote this user (scalar) fuction.
It's very basic;
-First; it's Right Trim (RTrim()) string
- And then Left Trim (LTrim())

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. CREATE FUNCTION dbo.Trim
  2. (
  3.    @string nvarchar(MAX)
  4. )
  5. RETURNS nvarchar(MAX)
  6. AS
  7. BEGIN
  8.    RETURN LTRIM(RTRIM(@string))
  9. END

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.