|
|
|
|
|
|
|
| Merge Two or More Columns Together with Comma - Sunday, May 11, 2008This example shows a method where you can merges different columns together with commas. In this example it takes address columns and merges them onto a single column. read more ...
|
|
| Find Email Address in Text Column - Saturday, March 29, 2008This script extracts an email address from within a TEXT Column within a table. Note this example only works in SQL Server 2005 and above. read more ...
|
|
| Find Email Address in VARCHAR - Wednesday, March 26, 2008This script display the email address contained in a VARCHAR column within a table. It does this by parsing apart the VARCHAR column to extract the email address using a single SELECT statement. read more ...
|
|
| Finding Email Address in String - Sunday, March 23, 2008This example extracts an email address from a string. It does this by parsing apart the email address one piece at a time. Eventually displaying just the email address contained in a string. read more ...
|
|
| Upper Case the First Character of Each Word - Sunday, February 03, 2008This is a function that uppercases the first character of each word of a string passed to this function. read more ...
|
|
| Remove White Space Between Two Words - Sunday, February 03, 2008This script removes the extra white space between two words. read more ...
|
|
| Removes White Space Between Multiple Words - Sunday, February 03, 2008This script removes all the white space between each word in a multi word string. read more ...
|
|
| Uppercasing First Character of Column - Sunday, February 03, 2008This script will uppercase the first character of a column. read more ...
|
|
| Padding with Zeroes - Sunday, February 03, 2008
|
|
| Padding with Zeroes Another Way - Sunday, February 03, 2008This script will pad a number with leading zeroes using the replicate function. read more ...
|
|
| Proper Case Person Name - Sunday, February 03, 2008This script will proper case the first, middle, and last name for a person. read more ...
|
|
| Find How Many Times One String Appears In Another - Sunday, February 03, 2008This script counts the number of occurrences of one string within another. read more ...
|
|
|
|
 |
|
|
|
|
|
|
|
|