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

Content with tag String Manipulation Rss

   Items 1 to 20 of 100    Older >>
 

Pad length

Pad string with a lenght of characters at front or back  Read more...
By Kraai 2016/04/28 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 294 reads

Finding Special Characters within Character Strings

Special Characters can lead to many problems. Identifying and reporting on them can save a lot of headache down the road.  Read more...
By Michael Morin 2016/04/08 (first published: 2014/08/19) | Source: SQLServerCentral.com | Category: special characters
Rating: |  Discuss |   Briefcase | 13,280 reads

Comparing string splitting / concatenation methods

Whenever a query is executed in SQL Server, its execution plan, as well as some useful execution data are placed into the plan cache for future use. This information is a treasure trove of metrics that can allow some very useful insight into your server’s performance and resource consumption - Ed Pollack shares some useful queries to start utilizing it.  Read more...
By Additional Articles 2016/03/16 | Source: SQLPerformance.com | Category: string manipulation
Rating:  Rate this |   Briefcase | 3,931 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,021 reads

The Path

By Steve Jones 2016/02/19 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,667 reads

What's the Length?

By Umer Akram 2016/01/11 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,611 reads

Search a string in a text with number of occurrences

IF you have a long string and if you want to search a specific input string, and number of timeS the string has occurred then it's helps  Read more...
Rating: |  Discuss |   Briefcase | 1,326 reads

Function for String Occurences Count

This function is used to get the particular string occurences count from the given input string.  Read more...
Rating: |  Discuss |   Briefcase | 1,080 reads

Lists

By Steve Jones 2014/12/23 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,185 reads

Split string using multiple delimiters - version 2

http://www.sqlservercentral.com/scripts/split+string/117123/ The above script will split upto 256 char length only. This new version will split upto N length.  Read more...
By Vignesh Arulmani 2014/11/21 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 1,234 reads

Split string using multiple delimiters

This script is used to split the string using multiple delimiters  Read more...
Rating: |  Discuss |   Briefcase | 1,657 reads

Remove Pattern Matched Characters

Remove characters matched in a patindex pattern recursively.  Read more...
By Steve Holle 2014/10/16 | Source: SQLServerCentral.com | Category: recursive
Rating: |  Discuss |   Briefcase | 1,134 reads

Find only characters or only integer from alphanumeric value

Extract only integers or characters from alphanumeric :  Read more...
By Vimal Lohani 2014/10/07 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,447 reads

Splitting Strings Based on Patterns

Splitting strings based on patterns supported by LIKE and PATINDEX can be an interesting way to address a wide variety of problems.  Read more...
By Dwain Camps 2014/09/12 (first published: 2012/11/29) | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 19,698 reads

Finding Special Characters within Character Strings

Special Characters can lead to many problems. Identifying and reporting on them can save a lot of headache down the road.  Read more...
By Michael Morin 2016/04/08 (first published: 2014/08/19) | Source: SQLServerCentral.com | Category: special characters
Rating: |  Discuss |   Briefcase | 13,280 reads

Hidden Formatting Troubles with STR() (SQL Spackle)

Fill in another bit of your T-SQL knowledge about STR(). It right justifies, rounds, and controls the output width of columns. Sounds perfect but here's why you might not want to use it.  Read more...
By Jeff Moden 2014/01/02 (first published: 2010/12/15) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 11,034 reads

CHARINDEX()

By Bill Lantz 2013/05/21 | Category: charindex
Rating: (not yet rated) |  Discuss |   Briefcase | 2,150 reads

LEN()

By Eduardo Rey 2013/03/29 | Category: len()
Rating: (not yet rated) |  Discuss |   Briefcase | 2,147 reads

Silent Truncation of SQL Server Data Inserts

There are certain circumstances where SQL Server will silently truncate data, without providing an error or warning, before it is inserted into a table. In this tip we cover some examples of when this occurs.  Read more...
By Additional Articles 2013/02/01 | Source: MSSQLTips.com | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 4,001 reads
   Items 1 to 20 of 100    Older >>
 
Tags
t-sql (52)    
delimited strings (6)    
sql server 2005 (6)    
advanced querying (5)    
arrays (5)    
counter (5)    
development (5)    
nums (5)    
parse (5)    
sqlinsider scripts (5)    
table of numbers (5)    
tally (5)    
xml (5)    
charindex (4)    
split string (4)    
blogs (3)    
sql server 7 (3)    
sqlclr (3)    
udf (3)    
user defined function (udf) (3)    
2-dimensional arrays (2)    
concat() (2)    
function (2)    
patindex (2)    
regular expressions (2)    
stuff() (2)    
administration (1)    
array (1)    
bigint (1)    
cast and convert (1)    
coalesce (1)    
collation (1)    
count (1)    
cross apply (1)    
cte (1)    
delimiters (1)    
etl (1)    
hex (1)    
input validation (1)    
int (1)    
integration services (ssis) (1)    
isnull (1)    
left() (1)    
len (1)    
len() (1)    
like (1)    
nvarchar (1)    
parsing column data (1)    
powershell (1)    
print (1)    
recursion (1)    
recursive (1)    
reverse (1)    
search (1)    
special characters (1)    
split string using delimiter (1)    
sql server string operation (1)    
sql spackle (1)    
string occurences (1)    
substring (1)    
tally table (1)    
text/ntext (1)    
trim (1)    
truncation (1)    
user defined function (1)    
user-defined functions (1)    
varchar (1)    
xquery (1)