Aug 19, 2009 · If we want to extract before the character you would put the charindex as the number of characters and start position as 0 in the substring function ----select characters before / select …

Aug 18, 2025 · This article takes a look at the changes in SQL Server 2025 to the SUBSTRING function.

Apr 24, 2018 · Home Forums SQL Server 2014 Development - SQL Server 2014 Remove duplicate substrings from string Post reply

Feb 13, 2009 · SQL Server vs Oracle: Substring Daniel Janik, 2017-09-05 (first published: 2017-08-23) Continuing the comparison between these two database giants, we dive into the substring function.

Apr 19, 2006 · Hi all, I am having issues when trying to truncate a DATETIME column using the SUBSTRING () function in a SELECT statement. I have tried using CAST and CONVERT functions …

May 22, 2001 · Extracting a string from between two delimiting characters The problem A table contains a column (particulars) consisting of a semi-colon-delimited string of text, for which the text between …

Jun 23, 2011 · If you're interested in updated speed comparisons on how fast each is (well, on SQL 2014 anyway), this LIKE vs SUBSTRING vs LEFT/RIGHT vs CHARINDEX article with benchmarks …

Feb 13, 2009 · To remove the part of string after the specific character, you use these transact-sql string functions as follow:

Feb 21, 2012 · Home Forums SQL Server 2008 T-SQL (SS2K8) Get the substring after second white space Post reply

Nov 23, 2009 · Home Forums SQL Server 7,2000 T-SQL Get Last Name, First name and Middle Name from Full Name Post reply 1 2 Next