Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag String Manipulation Rss

   Items 1 to 20 of 91    Older >>
 

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 | 934 reads

Split string using multiple delimiters

This script is used to split the string using multiple delimiters  Read more...
Rating: |  Discuss |   Briefcase | 1,405 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 | 978 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,308 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 | 18,487 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 2014/08/19 | Source: SQLServerCentral.com | Category: special characters
Rating: |  Discuss |   Briefcase | 9,561 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 | 10,991 reads

CHARINDEX()

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

LEN()

By Eduardo Rey 2013/03/29 | Category: len()
Rating: (not yet rated) |  Discuss |   Briefcase | 2,103 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 | 3,778 reads

STUFF - 2

By bitbucket-25253 2012/12/10 | Category: stuff
Rating: (not yet rated) |  Discuss |   Briefcase | 1,858 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 | 18,487 reads

STUFF - 1

By bitbucket-25253 2012/11/23 | Category: stuff
Rating: (not yet rated) |  Discuss |   Briefcase | 2,000 reads

Parsing Parameters in a Stored Procedure

This article shows a clean non-looping method to parse comma separated values from a parameter passed to a stored procedure.  Read more...
By Diego Buendía 2012/11/02 (first published: 2010/08/10) | Source: SQLServerCentral.com | Category: array
Rating: |  Discuss |   Briefcase | 28,333 reads

Key Word Searches

This article from Todd Fifield shows a Way to avoid the dreaded LIKE operator in your queries and dramatically speed up keyword searches.  Read more...
By Todd Fifield 2012/09/07 (first published: 2011/02/28) | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 34,706 reads

Trim Left Char (for single words)

Remove the first replications of a specified char in a word. It does not work well with text that contains blank spaces in the middle.  Read more...
By Adrian Facio 2012/08/16 | Source: SQLServerCentral.com | Category: trim
Rating: |  Discuss |   Briefcase | 922 reads

Padding function

Function that helps you to normalize numbers or strings.  Read more...
By Francis Jamet 2012/08/02 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 2,223 reads

Cast in Varchar with different options

By Paresh Patel 2012/07/16 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,033 reads

String Length

By Kenneth Fisher 2012/07/11 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,233 reads
   Items 1 to 20 of 91    Older >>
 
Tags
t-sql (48)    
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)    
blogs (3)    
split string (3)    
sql server 7 (3)    
sqlclr (3)    
user defined function (udf) (3)    
2-dimensional arrays (2)    
charindex (2)    
concat (t-sql) (2)    
function (2)    
regular expressions (2)    
stuff (2)    
udf (2)    
administration (1)    
array (1)    
bigint (1)    
cast and convert (1)    
coalesce (1)    
collation (1)    
cross apply (1)    
cte (1)    
delimiters (1)    
etl (1)    
hex (1)    
input validation (1)    
int (1)    
integration services (ssis) (1)    
isnull (1)    
len() (1)    
like (1)    
nvarchar (1)    
parsing column data (1)    
patindex (1)    
powershell (1)    
print (1)    
recursion (1)    
recursive (1)    
search (1)    
special characters (1)    
split string using delimiter (1)    
sql spackle (1)    
tally table (1)    
text/ntext (1)    
trim (1)    
truncation (1)    
user defined function (1)    
user-defined functions (1)    
varchar (1)    
xquery (1)