SQL SERVER – Connect Item – Vote for Feature Request Function TRIM

Till date, I have met the SQL Server Product Team twice: first time at SQL Server MVP Meet, Seattle, and second time at TechEd India 2009, Hyderabad. At both the times, I have put forth one request to the product team regarding implementing of function Trim(). As per my opinion, this is the most demanded feature of SQL Server. Almost all the programming languages have function TRIM() which removes space leading and any word that follows. However, SQL Server does not have TRIM() function. It has LTRIM() and RTRIM() functions, which when combined together LTRIM(RTRIM()) works like the expected TRIM() function – which I am proposing.

I have submitted the connect item for requesting TRIM() function. I am requesting all the users to vote for connect item and bring it up to the notice of SQL Server Product Group.

Microsoft Connect SQL Server – Feature Request TRIM()

If you are a SQL Server DBA you can think of the benefits you will gain after this function is implemented; you will save time and energy and there will be no more frustration! It is our moral duty to spread the word for this item and vote for implementation of this feature.

I had previously written the following three articles, which covers workaround, tricks and enhanced functions related to TRIM().

SQL SERVER – TRIM() Function – UDF TRIM()

SQL SERVER – 2008 – TRIM() Function – User Defined Function

SQL SERVER – 2008 – Enhenced TRIM() Function – Remove Trailing Spaces, Leading Spaces, White Space, Tabs, Carriage Returns, Line Feeds

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

3 thoughts on “SQL SERVER – Connect Item – Vote for Feature Request Function TRIM

  1. @Pinal

    Typo in the article. “Freature” has an extra “r”.

    Also, just added my vote. Thanx for bringing it up.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s