SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag SUBSTRING Rss

   Items 1 to 11 of 11   
 

SUBSTRING

By J. Drew Allen 2018/03/08 | Category: substring
Rating: (not yet rated) |  Discuss |   Briefcase | 1,132 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,617 reads

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: SQLServerCentral.com | Category: substring
Rating: |  Discuss |   Briefcase | 531 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: SQLServerCentral.com | Category: substring
Rating: |  Discuss |   Briefcase | 3,930 reads

Find a String in a String

Learn how you can find data in a string and extract it, no matter where it's located.  Read more...
By Steve Jones 2016/03/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,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: SQLServerCentral.com | Category: substring
Rating: |  Discuss |   Briefcase | 3,930 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,617 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: SQLServerCentral.com | Category: substring
Rating: |  Discuss |   Briefcase | 3,930 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: SQLServerCentral.com | Category: substring
Rating: |  Discuss |   Briefcase | 930 reads

Storing IPv4 Addresses for Performance

An in-depth analysis on how to store IPv4 addresses to achieve maximum efficiency and performance in both storage and queries  Read more...
By Jean-Sebastien Carle 2009/08/19 | Source: SQLServerCentral.com | Category: ipv4 addresses
Rating: |  Discuss |   Briefcase | 8,326 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: SQLServerCentral.com | Category: convert
Rating: |  Discuss |   Briefcase | 1,069 reads
   Items 1 to 11 of 11   
 
Tags
charindex (3)    
t-sql (3)    
patindex (2)    
cast (1)    
characters (1)    
convert (1)    
currency (1)    
datetime (1)    
function (1)    
ip addresses (1)    
ipv4 addresses (1)    
money (1)    
parse string (1)    
performance tuning (1)    
recursion (1)    
scalar udf (1)    
sql (1)    
storage (1)    
string manipulation (1)