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

Content with tags T-SQL, String Manipulation Rss

   Items 1 to 20 of 69    Older >>
 

PatExclude8K

Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)  Read more...
By Alan Burstein 2016/06/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,932 reads

More Unicode

By Steve Jones 2016/05/06 | Category: unicode
Rating: (not yet rated) |  Discuss |   Briefcase | 1,274 reads

UNICODE

By Steve Jones 2016/05/05 | Category: unicode
Rating: (not yet rated) |  Discuss |   Briefcase | 1,287 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,727 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,092 reads

PatExclude8K

Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)  Read more...
By Alan Burstein 2016/06/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,932 reads

The Path

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

What's the Length?

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

PatExclude8K

Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)  Read more...
By Alan Burstein 2016/06/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,932 reads

PatExclude8K

Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)  Read more...
By Alan Burstein 2016/06/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,932 reads

Lists

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

PatExclude8K

Removes characters in the a string (@string) that matches a specific pattern (updated 12-3-14)  Read more...
By Alan Burstein 2016/06/10 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,932 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,454 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,769 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,727 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,037 reads

CHARINDEX()

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

LEN()

By Eduardo Rey 2013/03/29 | Category: len()
Rating: (not yet rated) |  Discuss |   Briefcase | 2,152 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,069 reads
   Items 1 to 20 of 69    Older >>
 
Tags
sql server 2005 (6)    
advanced querying (5)    
arrays (5)    
counter (5)    
delimited strings (5)    
development (5)    
nums (5)    
parse (5)    
sqlinsider scripts (5)    
table of numbers (5)    
tally (5)    
charindex (3)    
patindex (3)    
sql server 7 (3)    
2-dimensional arrays (2)    
stuff() (2)    
tally table (2)    
unicode (2)    
user defined function (udf) (2)    
array (1)    
bigint (1)    
blogs (1)    
cast and convert (1)    
collation (1)    
cte (1)    
exclude pattern (1)    
hex (1)    
int (1)    
left() (1)    
len (1)    
len() (1)    
like (1)    
nvarchar (1)    
pattern exclude (1)    
recursion (1)    
regular expressions (1)    
reverse (1)    
search (1)    
set-based (1)    
special characters (1)    
sql spackle (1)    
sqlclr (1)    
string function (1)    
strings (1)    
substring (1)    
varchar (1)