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 84    Older >>
 

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,923 reads

CHARINDEX()

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

LEN()

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

STUFF - 2

By bitbucket-25253 2012/12/10 | Category: stuff
Rating: (not yet rated) |  Discuss |   Briefcase | 1,836 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 2012/11/29 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 9,840 reads

STUFF - 1

By bitbucket-25253 2012/11/23 | Category: stuff
Rating: (not yet rated) |  Discuss |   Briefcase | 1,980 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,218 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,650 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 | 911 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,213 reads

Cast in Varchar with different options

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

String Length

By Kenneth Fisher 2012/07/11 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 3,216 reads

T-SQL Integer Data-Type Conversions

This article will show some common integer data-type conversions using T-SQL.  Read more...
By Peter Kierstead 2012/06/26 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,870 reads

A CONCAT Function For The Rest Of Us

SQL Server 2012 introduces a new string concatenation function. This can be recreated in earlier versions of SQL Server.  Read more...
By Mike McQuillan 2012/06/06 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 2,039 reads

Converting String Data to XML and XML to String Data

In general XML documents or fragments are held in strings as text markup. In SQL Server, XML variables and columns are instead tokenised to allow rapid access to the data within. This is fine, but can cause some odd problems, such as ' entitization'. What do you do if you need to preserve the formatting? As usual Rob Sheldon comes to our aid.   Read more...
By Additional Articles 2012/02/07 | Source: SimpleTalk | Category: xml
Rating:  Rate this |   Briefcase | 3,496 reads

Strings and Defaults

By Gail Shaw 2012/01/26 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,460 reads

Stored procedure to find and replace text in a text file

find and replace text in a text file using tsql   Read more...
By Gene Hunter 2012/01/23 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 2,782 reads

Find occurence of any value in database!

Search entire database for occurrence of any text!  Read more...
By Reddy Software Solutions 2012/01/09 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 4,735 reads

IsAlphaNumeric

This script will determine if a string is alphanumeric   Read more...
By Jon McGhee 2011/12/01 | Source: SQLServerCentral.com | Category: input validation
Rating: |  Discuss |   Briefcase | 1,215 reads
   Items 1 to 20 of 84    Older >>
 
Tags
t-sql (45)    
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)    
sql server 7 (3)    
sqlclr (3)    
user defined function (udf) (3)    
2-dimensional arrays (2)    
charindex (2)    
concat (t-sql) (2)    
function (2)    
stuff (2)    
udf (2)    
administration (1)    
array (1)    
bigint (1)    
cast and convert (1)    
coalesce (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)    
search (1)    
split string (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)