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

Content with tags T-SQL, String Manipulation Rss

<< Newer    Items 21 to 40 of 58    Older >>
 

Retrieve numbers from a string

This function will take a string parameter and find all numbers in it.  Read more...
By Boyd Tyrrell 2011/07/20 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 2,817 reads

Concatenating Rows

Often in database design we store different values in rows to take advantage of a normalized design. However many times we need to combine multiple rows of data into one row for a report of some sort. New author Carl P. Anderson brings us some interesting T-SQL code to accomplish this.  Read more...
By Carl P. Anderson 2011/03/04 (first published: 2009/10/14) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 147,462 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,733 reads

String tokenizing / splitting

We often have need of string splitting in applications. I had need of one in some T-SQL development I am currently doing for a friend.  Read more...
By Irfan Baig 2011/02/25 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 1,920 reads

SQL CLR Function for Email validation and string Split

I have added 2 functions here, one for email validation and another to split the string by specified separator by user.  Read more...
By Bharat Panthee 2010/12/23 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,445 reads

Charpad - Character Padding Function

A generic character padding function. Useful for situations where you need fixed width formatting e.g. email reports.  Read more...
By Richard Doering 2010/12/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,959 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,002 reads

Change String to Title Case(Initcap)

This is simple script to change string to title case. It will take string in any case and convert it to initcap.  Read more...
By Abdul Rahman 2010/10/26 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 1,429 reads

Robyn Page's SQL Server String Manipulation Workbench

String searching and manipulation in SQL Server can be error-prone and tedious...unless you're armed with the techniques described in Robyn's string manipulation workbench, here newly revised with extra material from collaborator Phil Factor  Read more...
By Additional Articles 2010/10/19 | Source: SimpleTalk | Category: string manipulation
Rating:  Rate this |   Briefcase | 4,033 reads

Detective Stories - Changing the Case

How to change your "UPPER" or "lower" case strings to a mixed case  Read more...
By Brandie Tarvin 2010/10/18 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 5,999 reads

Way to Check Multiple LIKE without dynamic SQL

I was asked to do so by one of my colleague. So, I thought to share it with you how to use multiple LIKE conditions.  Read more...
By Atif-ullah Sheikh 2010/09/16 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 3,477 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,442 reads

Tally Table Uses - Part II

In part II of his series, Stefan Krzywicki shos us another way Tally Tables have helped solve problems - Text Parsing.  Read more...
By Sioban Krzywicki 2010/08/03 | Source: SQLServerCentral.com | Category: tally table
Rating: |  Discuss |   Briefcase | 8,541 reads

Trim Non-Alpha characters from string

Trim Non-Alpha characters from string  Read more...
By Atif-ullah Sheikh 2010/07/20 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 2,417 reads

Get concatenated value for a column without cursor

This script provides comma separated values of one column for each value of another column. It provides it in SQL 2005 without using cursor.  Read more...
By Nitin Bhargava 2010/07/06 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,232 reads

Charpad - Character Padding Function

A generic character padding function. Useful for situations where you need fixed width formatting e.g. email reports.  Read more...
By Richard Doering 2010/12/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,959 reads

Retrieve numbers from a string

This function will take a string parameter and find all numbers in it.  Read more...
By Boyd Tyrrell 2011/07/20 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 2,817 reads

Concatenation Cursor

By D Sanborn 2010/02/16 | Category: string manipulation
Rating: (not yet rated) |  Discuss |   Briefcase | 3,573 reads

Characters

No, I’m not talking about a Dickens novel. I’m talking about the number of characters in a string. I had a painful time recently because of the word “characters.”   Read more...
By Steve Jones 2009/10/26 | Source: SQLServerCentral.com | Category: blogs
Rating:  Rate this |   Briefcase | 1,690 reads

Concatenating Rows

Often in database design we store different values in rows to take advantage of a normalized design. However many times we need to combine multiple rows of data into one row for a report of some sort. New author Carl P. Anderson brings us some interesting T-SQL code to accomplish this.  Read more...
By Carl P. Anderson 2011/03/04 (first published: 2009/10/14) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 147,462 reads
<< Newer    Items 21 to 40 of 58    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)    
sql server 7 (3)    
2-dimensional arrays (2)    
stuff (2)    
user defined function (udf) (2)    
array (1)    
bigint (1)    
blogs (1)    
cast and convert (1)    
charindex (1)    
collation (1)    
cte (1)    
hex (1)    
int (1)    
len() (1)    
like (1)    
nvarchar (1)    
patindex (1)    
recursion (1)    
regular expressions (1)    
search (1)    
special characters (1)    
sql spackle (1)    
sqlclr (1)    
tally table (1)    
varchar (1)