No announcements
Found 1763576 threads
-
0 VotesRemoving Commas in dervied column?
REPLACE(input,",","") : input --remove first comma FINDSTRING(input,",",1) == 1 ?Answered | 5 Replies | 4697 Views | Created by Prakash.R - Monday, January 23, 2012 12:39 PM | Last reply by Prakash.R - Tuesday, January 24, 2012 8:40 AM
-
5 Votes
How to remove a comma in a line?
He wants to remove all commas after the 4th so he has 5 columns.Answered | 20 Replies | 4450 Views | Created by allan8964 - Wednesday, January 11, 2012 4:59 AM | Last reply by allan8964 - Monday, January 16, 2012 5:55 PM -
0 Votes
how to remove all commas in a string
Is that possible to remove all comma in a string ?Answered | 1 Replies | 3839 Views | Created by sdnd2000 - Thursday, August 15, 2013 9:28 AM | Last reply by Johnny Bell Jnr - Thursday, August 15, 2013 9:30 AM -
0 Votes
Remove comma
Note that the solution you have now has more serious problems than just the leading comma: it depends on undefined behaviour.Answered | 6 Replies | 2381 Views | Created by z.a.k - Monday, April 23, 2012 10:51 AM | Last reply by Erland Sommarskog - Monday, April 23, 2012 11:16 AM -
0 Votes
Remove Comma from SQL String
0 Then Left(RTrim(Titles), Len(Titles) - 1) Else Titles End Where Right(RTrim(Titles), 1) = ',' -- check result of update Select Titles From @Test; As with any update, ...Answered | 3 Replies | 7964 Views | Created by IndigoMontoya - Thursday, December 27, 2012 3:35 AM | Last reply by Eswararao C - Thursday, December 27, 2012 4:30 AM -
0 Votes
clean up code that simply removes the last comma of a comma separated string ?
o.IsChecked) .Select(o=>o.ProductInfoUID.ToString()) .ToArray() ); UpdateRequestProductInfo(MyProductInfoItems, text); To me, I ...Answered | 7 Replies | 11211 Views | Created by hazz - Saturday, October 1, 2011 5:59 PM | Last reply by nhclick - Friday, October 7, 2011 2:30 AM -
1 Votes
Need to Remove Comma at the end.
Different ways to generate Comma separated list: https://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/ Choose the one ...Answered | 5 Replies | 1283 Views | Created by NguyenBL - Thursday, November 14, 2013 5:38 PM | Last reply by Venkataraman R - Friday, November 15, 2013 6:45 AM -
2 Votes
Remove last Comma from the string
Be aware that the combination of RIGHT and LEN will have problems if SPACE characters follow the comma and you still want the trailing comma ...Answered | 8 Replies | 92606 Views | Created by Mears - Tuesday, March 11, 2008 7:20 PM | Last reply by GopalaKrihsnaReddy Katla - Tuesday, July 8, 2014 5:31 AM -
1 Votes
Convert varchar to int and remove commas
Does your boss treat you that way and expect you to program?Answered | 4 Replies | 7828 Views | Created by DavidWIII - Monday, July 22, 2013 3:06 PM | Last reply by --CELKO-- - Monday, July 22, 2013 3:31 PM -
0 Votes
Remove ALL characters from string except commas
Just our of curiosity is there a way to combine this like of code?Answered | 4 Replies | 745 Views | Created by Ryan0827 - Monday, April 21, 2014 7:24 PM | Last reply by Hans Vogelaar MVP - Tuesday, April 22, 2014 2:16 PM -
0 Votes
Removing comma from a flat file
Convention depicts that any columns with embedded commas should be enclosed in quotes, are you able to get the source regenerated to meet this?Answered | 4 Replies | 1960 Views | Created by Adarsh.mp - Sunday, July 17, 2016 3:35 PM | Last reply by Adarsh.mp - Tuesday, July 19, 2016 10:40 AM -
0 Votes
Is there a better way?
Casting a datetime to date will remove the time portion; there are other ways to achieve that as well.Answered | 4 Replies | 1719 Views | Created by RJ454M3 - Friday, January 11, 2013 7:52 PM | Last reply by Barry Marshall - Friday, January 11, 2013 9:08 PM -
0 Votes
execCommand - is there a better way?
Is there a better way to keep the current selection when using execCommand().Answered | 1 Replies | 1925 Views | Created by Emil Pirfält - Tuesday, September 25, 2012 5:50 PM | Last reply by Song Tian - Wednesday, September 26, 2012 7:59 AM -
0 Votes
Better way of removing commas
Unfortunatley the originator of the string is ouputing commas within the string such as "1,234,567.89" What is the best ...Answered | 11 Replies | 19786 Views | Created by OmegaMan - Monday, June 26, 2006 8:29 PM | Last reply by Sergei Z - Friday, February 2, 2007 6:08 PM -
0 Votes
Better ways- SPSite.AllWebs usage
Give this a try - http://hristopavlov.wordpress.com/2008/10/20/a-very-fast-method-to-get-the-site-collections-web-structure/ It will get you a list of all the webs in a site (giving ...Answered | 2 Replies | 5943 Views | Created by Raj_Tech - Thursday, December 18, 2008 3:13 PM | Last reply by Dan Keeling - Friday, December 19, 2008 3:06 AM -
1 Votes
Replace comma
if you get the index of the comma and place it into a int. then remove the comma and finally insert " and" at the index that the comma was at.Answered | 2 Replies | 4734 Views | Created by MDMoura - Saturday, November 22, 2008 1:15 AM | Last reply by ronan001 - Saturday, November 22, 2008 2:09 AM -
2 Votes
commas
It turns out that I forgot the comma next to the field name inside the ().Answered | 3 Replies | 6728 Views | Created by pawoodsy - Tuesday, November 9, 2010 12:51 PM | Last reply by DJ TUeRIO SET - Tuesday, March 5, 2013 8:19 AM -
1 Votes
Better way to write this Query
It looks better from the maintenance point of view.Answered | 6 Replies | 1164 Views | Created by Diango - Monday, December 30, 2013 2:34 PM | Last reply by Naomi N - Monday, December 30, 2013 8:48 PM -
6 Votes
Better way to select records?
Why is the optimizer restricted in any way by my use of "INNER JOIN ...Answered | 12 Replies | 1933 Views | Created by Kenrav - Tuesday, March 20, 2012 3:00 AM | Last reply by datAdrenaline - Thursday, March 22, 2012 5:11 PM -
1 Votes
Way to make query better
Please post the screen shots of the Execution plan which will help us to help you in a better way.Answered | 2 Replies | 2527 Views | Created by Chickoo79 - Tuesday, December 18, 2012 10:58 AM | Last reply by Kalman Toth - Wednesday, December 19, 2012 1:23 AM - Items 1 to 20 of 1763576 Next ›
No announcements
