Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts with tag SUBSTRING Rss

Search for any content tagged substring

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 5 of 5   

Equivalent Oracle's INSTR Function in SQL server

Oracle Built in Function INSTR is a great function if you wish to locate a string or a subset of string in the nth place.  Read more...
By Hannan Kravitz 2016/11/17 | Source: | Category: substring
Rating: |  Discuss |   Briefcase | 475 reads

Extracting string after and before a Character/Pattern

Finding characters/string before and after some character or pattern  Read more...
Rating: |  Discuss |   Briefcase | 1,558 reads

Split String Function

This In-line Table Valued Function returns a table with individual records parsed from a string.  Read more...
By Chris Kutsch 2016/08/26 | Source: | Category: substring
Rating: |  Discuss |   Briefcase | 3,866 reads

Format Currency Into a String

I had a requirement to produce a formatted currency string from within SQL server. I was able to build this scalar-valued function to meet the requirement.  Read more...
By Chris Kutsch 2013/05/13 | Source: | Category: substring
Rating: |  Discuss |   Briefcase | 919 reads

GetDateTime Function

This function gets a variable string and converts to DateTime format 'YYYY-MM-DD HH:MM' Ex. '200907111405' Convert to '2009-07-11 14:05:00'   Read more...
By Luis Atondo 2009/07/30 | Source: | Category: convert
Rating: |  Discuss |   Briefcase | 1,067 reads
   Items 1 to 5 of 5