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

Scripts with tag String Manipulation Rss

Search for any content tagged string manipulation

Get your favourite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 20 of 39    Older >>
 

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

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

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

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

Get Item from Delimited List at Position

Returns the item from a delimited list at the specified position. Both position and delimiter are parameters.  Read more...
By Chad Casady 2011/03/10 | Source: SQLServerCentral.com | Category: udf
Rating: |  Discuss |   Briefcase | 1,016 reads

Prepend Value to Delimited List

Takes a delimited list and prepends a value to the beginning.  Read more...
By Chad Casady 2011/03/09 | Source: SQLServerCentral.com | Category: udf
Rating: |  Discuss |   Briefcase | 768 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,854 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,386 reads

Format Phone Number function

Function to format phone numbers entered as text.   Read more...
By Harsha Majety 2010/12/07 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 1,952 reads

SQL Function to Split Comma Separated Values and Insert into Table

SQL Function to Split Comma Separated Values and Insert into Table  Read more...
By Lokeshkumar 2010/11/30 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 3,936 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,405 reads

UDF: Phone Format

Format phone number to standard format '(xxx) xxx-xxxx' Removes non numeric characters from string and returns standard format.  Read more...
By saul.g.perez 2010/10/27 | Source: SQLServerCentral.com | Category: user defined function
Rating: |  Discuss |   Briefcase | 1,199 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,442 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,357 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,200 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,911 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,776 reads

Using a function to parse/return the Nth field of a delimited column

A useful SQL function to parse a single string with delimited values for the "N"th occurrence  Read more...
By John Burnette 2009/11/06 | Source: SQLServerCentral.com | Category: etl
Rating: |  Discuss |   Briefcase | 1,219 reads

Splitting the string with unique delimiter.

The statement is splited into columns according the delimter and it has been captured in the table datatype.  Read more...
By Prashanth Jayaram 2009/06/29 | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 1,100 reads

Function to return proper case

This function returns the proper case of any given string.   Read more...
By Sean Cooperman 2009/03/19 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 1,295 reads
   Items 1 to 20 of 39    Older >>