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

    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 …

  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 …

  5. Which is more efficient? WHERE SUBSTRING = ...or

    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 …

  6. 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:

  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 …

  8. Get Last Name, First name and Middle Name from Full Name

    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

  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, …

  10. substring with Charindex – SQLServerCentral Forums

    Jan 8, 2019 · Home Forums SQL Server 2017 SQL Server 2017 - Development substring with Charindex Post reply 1 2 Next