No announcements
Found 1930900 threads
-
1 VotesSelect number from string before 'days' substring
Hello, You can use the REVERSE function to turn the string around, search for first "days" and the following next space to allocate the number in front ...Answered | 3 Replies | 876 Views | Created by Aikiway - Wednesday, July 20, 2016 3:51 PM | Last reply by Sam Zha - Thursday, July 21, 2016 8:19 AM
-
4 Votes
Get Numbers from a String
For a more generic problem of extracting numbers from a string, take a look at this blog post Extracting numbers ...Answered | 8 Replies | 3081 Views | Created by Sharath048 - Thursday, December 1, 2011 9:32 AM | Last reply by Sharath048 - Friday, December 2, 2011 5:29 AM -
0 Votes
Extracting a number from a string
I suggest you firstly copy the table from Access DB to SQL DB with import wizard, then insert the data to destination table with following SQL ...Answered | 3 Replies | 1604 Views | Created by Debra has a question - Monday, May 30, 2016 7:14 PM | Last reply by Seif Wang - Thursday, June 2, 2016 11:20 AM -
2 Votes
Selecting from string
.* would this be everything from start and .*$ everything to end?Answered | 14 Replies | 832 Views | Created by yaro137 - Tuesday, May 15, 2018 9:02 AM | Last reply by Rich Matheisen [Ex-MVP (retired)] - Sunday, May 20, 2018 3:46 AM -
1 Votes
Replacing numbers from a string
@X = REPLACE(@X,NUMBER,'') FROM MASTER.Answered | 6 Replies | 53985 Views | Created by MrFlinstone - Monday, September 20, 2010 10:23 AM | Last reply by --CELKO-- - Monday, September 20, 2010 5:53 PM -
0 Votes
Get only the number from a string.
SELECT dbo.ExtractInteger('My 3rd Phone Number is 323-111-CALL') GOAnswered | 8 Replies | 26022 Views | Created by chautt - Sunday, February 5, 2012 8:43 AM | Last reply by MImtiyaz - Thursday, September 18, 2014 10:21 AM -
0 Votes
Problem with concatenating strings in select
You can also use coleasce to get result: Declare @vComma Varchar(max); Select @vComma = COALESCE(@vComma+';','') + cast(column1 as varchar(50)) ...Answered | 3 Replies | 3893 Views | Created by Barbi Rio - Thursday, July 30, 2009 4:42 AM | Last reply by Shamas Saeed - Thursday, July 30, 2009 5:15 AM -
0 Votes
Find number from a string
I have config value and I am storing this entire line as string (like $myVal = <add key="Backup" value="3:w" />).Answered | 1 Replies | 2171 Views | Created by Deepak Khare - Tuesday, July 31, 2012 12:36 AM | Last reply by RiffyRiot - Tuesday, July 31, 2012 1:15 AM -
6 Votes
Extract first number from string
Hi Marcel, Thanks for pointing "E" problem.Answered | 8 Replies | 4789 Views | Created by BrandyBill - Wednesday, August 2, 2017 11:09 AM | Last reply by Imke Feldmann - Sunday, August 6, 2017 7:37 AM -
0 Votes
get 10 digit number from string
Let me know if this resolves your problem.Answered | 10 Replies | 6921 Views | Created by BI_Support - Thursday, May 30, 2013 8:33 AM | Last reply by shenoyp - Friday, May 31, 2013 4:43 PM -
0 Votes
How to extract numbers from string
I notice now that I did not cover this case: "Also, any record that doesn't have any numbers should output the number 3.Answered | 4 Replies | 8223 Views | Created by Debra has a question - Monday, July 18, 2016 7:26 PM | Last reply by pituach - Monday, July 18, 2016 10:50 PM -
1 Votes
get number from string in log files
If you just want the largest number then just sort the output of the first example If you want just numbers here are just the ...Answered | 8 Replies | 3985 Views | Created by Rick Roen - Saturday, July 7, 2012 2:27 PM | Last reply by jrv - Sunday, July 8, 2012 5:11 PM -
2 Votes
How to get a number from a string
That is what happens when you come from a family of wizards and warlocks.Answered | 12 Replies | 745 Views | Created by Bjoern It B ti - Monday, December 7, 2015 9:04 PM | Last reply by Bjoern It B ti - Tuesday, December 8, 2015 10:44 PM -
1 Votes
SELECT a String record from a table
So the problem can be caused by the second slash in your string, it can be a Chinese symbol.Answered | 8 Replies | 847 Views | Created by SQL_Gun - Tuesday, March 3, 2015 5:24 AM | Last reply by Charlie Liao - Thursday, March 5, 2015 8:51 AM -
1 Votes
Find and replace a number with in a string
create table test (id int,col varchar(30) ) insert into test (id,col) values(1,'5AB89C'),(2,'GH1HJ'),(3,'N99K7H45') ;with Num1 (n) AS ...Answered | 5 Replies | 1308 Views | Created by Naveen JV - Tuesday, April 9, 2019 10:51 AM | Last reply by Naveen JV - Wednesday, April 10, 2019 12:51 PM -
0 Votes
Select * INTO ...
SELECT @SelectList = @SelectList + COALESCE( '[' + Column_name + ']' + ', ' ,'') FROM information_schema.columns WHERE table_name = ...Answered | 2 Replies | 5005 Views | Created by RDuke - Wednesday, March 10, 2010 8:07 PM | Last reply by RDuke - Wednesday, March 10, 2010 8:28 PM -
1 Votes
Select from delimited comma string
You need to create this as a dynamic SQL string then execute it, like: NO!Answered | 2 Replies | 10300 Views | Created by Benjamin Quintino - Saturday, December 11, 2010 2:27 PM | Last reply by Erland Sommarskog - Saturday, December 11, 2010 6:05 PM -
0 Votes
select-string / multiple matches
Use Get-ChildItem to select the needed files, Select-String to find the needed string, and output the Path, LineNumber, and Line properties from each ...Answered | 4 Replies | 2008 Views | Created by BAWrites - Friday, May 20, 2016 8:03 PM | Last reply by BAWrites - Friday, June 24, 2016 12:34 AM -
4 Votes
Parse a number from string and form a date in SQL
SELECT Format(EOMONTH(Cast(Replace(Replace(Replace(theCol,'WorkProgress ',''), '(',''),')','') as date)),'yyyyMMdd') ...Answered | 3 Replies | 788 Views | Created by CSKKingsForEver - Thursday, August 18, 2016 8:05 PM | Last reply by Jingyang Li - Thursday, August 18, 2016 9:24 PM -
4 Votes
How to select the last characters from a string?
hey rayen, if you looking the last char from string it's easy to get if from "LEFT" or "RIGHT" function.Answered | 18 Replies | 1839 Views | Created by ironryan77 - Thursday, June 19, 2014 3:35 PM | Last reply by - Friday, June 20, 2014 4:14 PM - Items 1 to 20 of 1930900 Next ›
No announcements
