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

Content with tag SUBSTRING Rss

   Items 1 to 6 of 6   
 

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/02/10 | Source: SQLServerCentral.com | Category: substring
Rating: |  Discuss |   Briefcase | 3,038 reads

Extarcting string after and before a Character/Pattern

Finding characters/string before and after some character or pattern  Read more...
Rating: |  Discuss |   Briefcase | 1,149 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/02/10 | Source: SQLServerCentral.com | Category: substring
Rating: |  Discuss |   Briefcase | 3,038 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 | 915 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,312 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,056 reads
   Items 1 to 6 of 6   
 
Tags
cast (1)    
characters (1)    
charindex (1)    
convert (1)    
currency (1)    
datetime (1)    
function (1)    
ip addresses (1)    
ipv4 addresses (1)    
money (1)    
parse string (1)    
patindex (1)    
performance tuning (1)    
recursion (1)    
scalar udf (1)    
sql (1)    
storage (1)    
tsql (1)    
t-sql (1)