No announcements
Found 3577017 threads
-
0 VotesHelp with Trimming Characters in the select statement
Another way is this =Trim(Split(Fields!Answered | 3 Replies | 743 Views | Created by bhanu_nz - Sunday, August 24, 2014 11:38 PM | Last reply by Visakh16 - Monday, August 25, 2014 6:07 AM
-
0 Votes
how to trim spaces in the query result
Instead of using <> you can use char(7) which is very unlikely in the data.Answered | 12 Replies | 10345 Views | Created by IdentityProfile - Wednesday, October 31, 2007 2:59 PM | Last reply by Gert-Jan Strik - Friday, May 14, 2010 6:23 PM -
1 Votes
Correct Use of Trim
Be aware that Trim is in two formats in VB, one as a method from ...Answered | 6 Replies | 1740 Views | Created by Bgeo25 - Sunday, May 20, 2012 2:22 AM | Last reply by Cor Ligthert - Tuesday, May 22, 2012 7:07 AM -
0 Votes
Trim Function
then I use query like below.Answered | 7 Replies | 530 Views | Created by FSalgueiro - Monday, May 1, 2017 2:29 PM | Last reply by QA Guy CommElec - Tuesday, May 2, 2017 5:19 PM -
3 Votes
Use of Trim in derived Column
Do you know what the TRIM function does?Answered | 11 Replies | 12289 Views | Created by Amit Srivastava - Tuesday, April 3, 2012 12:49 PM | Last reply by ArthurZ - Tuesday, April 3, 2012 6:10 PM -
0 Votes
trim$
There areAnswered | 3 Replies | 632 Views | Created by joesmith1817 - Friday, July 25, 2014 3:31 PM | Last reply by Kareninstructor - Friday, July 25, 2014 10:16 PM -
0 Votes
trim
Aaron, How would using a scalar UDF compare performance wise compared to simply SELECT LTrim(RTrim(my_column))?Answered | 3 Replies | 5368 Views | Created by Jackson_1990 - Friday, December 12, 2008 5:13 AM | Last reply by Sankar Reddy - Wednesday, December 17, 2008 12:59 AM -
0 Votes
Trim function for report data ?
If you use trim in your SQL, you will create an alias for the column name.Answered | 5 Replies | 704 Views | Created by AllTheGoodNamesWereTaken - Friday, November 6, 2015 12:46 AM | Last reply by RunningManHD - Monday, November 9, 2015 8:44 PM -
0 Votes
Dimension Trimming
You will see that when you click Build Query, it will only show you the dimension that is currently having security applied to it.Answered | 1 Replies | 5944 Views | Created by SQLIdiot - Thursday, July 2, 2009 5:32 PM | Last reply by Josh Ashwood - Friday, July 3, 2009 1:39 AM -
0 Votes
Use the trim function in Infopath
Use normalize-space function.Answered | 3 Replies | 3037 Views | Created by Matthias1012 - Friday, November 20, 2015 2:49 PM | Last reply by b87 - Wednesday, July 5, 2017 6:48 AM -
0 Votes
Report Builder uses TRIM; what is SQL equivalent?
Answered | 3 Replies | 9341 Views | Created by mtpaper - Sunday, January 30, 2011 5:04 PM | Last reply by Chintak Chhapia - Sunday, January 30, 2011 10:41 PM -
5 Votes
Trim Function
Instead of trying to trim this in a query oer and over and over, why not clean up the table?Answered | 9 Replies | 880 Views | Created by Murali dhar - Thursday, May 15, 2014 4:37 PM | Last reply by Murali dhar - Thursday, May 15, 2014 6:08 PM -
0 Votes
using function in select query
Why not to use GETDATE()?Answered | 3 Replies | 51337 Views | Created by dpkas - Friday, April 15, 2011 12:24 PM | Last reply by Atif-ullah Sheikh - Friday, April 15, 2011 12:38 PM -
1 Votes
meaning of "security trimmed"?
Only because security trimming as an action is relevent to an account, not specifically to a user account per se and many services that run using a given service account ...Answered | 4 Replies | 5920 Views | Created by QBOAT - Thursday, April 19, 2012 11:16 AM | Last reply by John Timney MVP - Thursday, April 19, 2012 12:01 PM -
0 Votes
Trim to a \
Eric Zhang TechNet Community SupportAnswered | 4 Replies | 1431 Views | Created by D Ards - Wednesday, August 19, 2015 4:08 PM | Last reply by Eric__Zhang - Thursday, August 20, 2015 1:02 AM -
0 Votes
trimming
Hi Riten900, The key is that the String.Trim() method will remove both the leading and tailing white space character, and the ...Answered | 6 Replies | 3386 Views | Created by Riten900 - Wednesday, March 9, 2011 1:05 AM | Last reply by Ouch Liu - Wednesday, March 9, 2011 3:22 AM -
0 Votes
soreprocedure using in the select query
Method 3 usign CTE (common table expression) with cte as ( SELECT EMPLOYEE_MF.EMP_NO, ...Answered | 2 Replies | 1404 Views | Created by jessy varkey - Thursday, March 21, 2013 10:14 AM | Last reply by Uri Dimant - Thursday, March 21, 2013 10:46 AM -
2 Votes
Does getting items by caml query automatically get security trimmed?
Yes Girish is correct, The items would be security trimmed.Answered | 3 Replies | 2798 Views | Created by sp.user - Thursday, July 4, 2013 4:20 PM | Last reply by Divya Akula - Thursday, July 4, 2013 5:49 PM -
0 Votes
Trim in a where statement
for TRIM(value) you'll have to use LTRIM(RTRIM(value))Answered | 2 Replies | 3592 Views | Created by harrytu - Tuesday, February 14, 2012 3:27 PM | Last reply by tkrasinger - Wednesday, February 15, 2012 10:01 AM -
0 Votes
trimming string
hi, Trim() can be used.Answered | 3 Replies | 2691 Views | Created by Sheen Ismhael Lim - Monday, March 15, 2010 5:38 AM | Last reply by aniruddha84 - Monday, March 15, 2010 8:29 AM - Items 1 to 20 of 3577017 Next ›
No announcements
