About 50 results
Open links in new tab
  1. T-SQL in SQL Server 2025: Substring Changes – SQLServerCentral

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

  2. Extracting string after and before a Character/Pattern

    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 …

  3. Get the substring after second white space - SQLServerCentral

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

  4. SQL Server vs Oracle: Substring – SQLServerCentral

    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.

  5. Removing part of string before and after specific character using ...

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

  6. Which is more efficient? WHERE SUBSTRING = ...or ... - SQLServerCentral

    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 …

  7. Extracting a String From Between Two Delimiting Characters

    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 …

  8. SUBSTRING a DATETIME value in a SELECT statement

    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 …

  9. How to get a substring between two characters? - SQLServerCentral

    Aug 16, 2010 · Kevin This sort of string manipulation is best performed by your application rather than SQL Server. If you really need to do it, you should be able to use the LEFT, RIGHT, SUBSTRING …

  10. SUBSTRING And CHARINDEX to find start/end of string

    Oct 7, 2012 · Home Forums SQL Server 7,2000 T-SQL SUBSTRING And CHARINDEX to find start/end of string Post reply