Search
Active

35
Sign in to vote
3
Sign in to vote
Sign in
 to vote
Type: Bug
ID: 459062
Opened: 5/27/2009 5:34:04 AM
Access Restriction: Public
2
Workaround(s)
36
User(s) can reproduce this bug
This is my first time using connect.
Almost all the programming language have function TRIM() which removes space leading and following any word. However, SQL Server does not have TRIM() function.

SQL Server has LTRIM() and RTRIM() function when combined like LTRIM(RTRIM()) it works same as expected TRIM() function - which I am proposing.

This might be reported earlier but this is one request I think is the most requested in development community.
Details (expand)
What is your OneCare version?
(To check your build version; open Windows Live OneCare, in the upper right click Help, then select About Windows Live OneCare... Your version will be listed near the top).
I don't know or other
Operating System
Windows Vista
Bug Type
Other
SubType
Other
How often does this happen?
Always Happens
Have you seen this problem before in this product?
Yes, this happens in all previous versions
Reproduction Steps
 
Expected Results
TRIM() function is implemented which works same as LTRIM(RTRIM())
File Attachments
0 attachments
Sign in to post a comment.
Posted by Mike C# on 5/31/2009 at 6:26 PM
Hallelujah
Posted by Ritesh Modi on 6/3/2009 at 11:47 PM
Yes this really required function. while Using RTRIM() and LTRIM we need to run two functions. TRIM function will remove this.
Posted by DotNetVJ on 6/8/2009 at 11:45 AM
We need this..otherwise we will end in writing our code :D
Posted by slewka on 6/14/2009 at 12:55 PM
It will be really useful
Posted by diana_moldovan on 6/15/2009 at 12:30 PM
TRIM() would be great...I am such a lazy person...:)
© 2009 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement