<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Content with tag
String Manipulation
Refine your search with one of the following additional tags (with number of items):
T-SQL
(7)
Concatenate
(1)
Search
(1)
User Defined Function
(1)
Administration
(1)
ISNULL
(1)
T-SQL Aids
(1)
XML
(1)
Coalesce
(1)
Print
(1)
UDF
(1)
XQUERY
(1)
Items 1 to 14 of 14
Create string from table
This simple script retrieves a range of values from a table and presents the results as a string.
Read more...
By
Dave
2008/09/15
|
Source:
SQLServerCentral.com
|
Category:
Coalesce
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2 reads
LongPrint
Simple script overcomes the 8000 character limitation in the T-SQL print Command
Read more...
By
Timothy A Wiseman
2008/07/28
|
Source:
SQLServerCentral.com
|
Category:
Print
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
7 reads
Owning the Spelling Suggestion Feature
To create your own spelling suggestion feature, you need a look-up with correct spellings and misspellings. I walk you through it.
Read more...
By
Bill Nicolich
2008/07/21
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
3,677 reads
How do I ... reject alpha characters in a SQL Server character column?
Enforcing your data's integrity is probably the single most important issue you face when designing a database. Validating user input is one way of keeping bad data from making its way into your analyses and reports.
Read more...
By
Additional Articles
2008/06/04
|
Source:
Builder.com
|
Category:
T-SQL
Rating:
Rate this
|
Briefcase
|
2,615 reads
SQL String User Function Workbench: part 1
Robyn and Phil go back to basics and hammer out some basic String-handling User Functions in TSQL, based on Python examples. Plenty of sample code, and TSQL programming tricks.
Read more...
By
Additional Articles
2008/04/22
|
Source:
SimpleTalk
|
Category:
T-SQL
Rating:
Rate this
|
Briefcase
|
3,266 reads
Padding function
Function that helps you to normalize numbers or strings.
Read more...
By
Francis Jamet
2008/04/21
|
Source:
SQLServerCentral.com
|
Category:
String Manipulation
Rating:
|
Discuss
|
Briefcase
|
875 reads
Find and Replace a String in the Whole Database
Find and Replace a string in all string fields (char, varchar, etc) of all tables in the database
Read more...
By
Luiz Barros
2008/04/11
|
Source:
SQLServerCentral.com
|
Category:
String Manipulation
Rating:
|
Discuss
|
Briefcase
|
1,415 reads
Trim Trailing Blanks in SQL Queries
Reformats the text output of queries to trim trailing blanks in wide varchar columns for easy copy-and-paste.
Read more...
By
Jesse McLain
2008/03/10
|
Source:
SQLServerCentral.com
|
Category:
T-SQL Aids
Rating:
|
Discuss
|
Briefcase
|
1,156 reads
Get given character's position from a string
Get given character's position from a string
Read more...
By
hxd001_810
2008/02/13
|
Source:
SQLServerCentral.com
|
Category:
User Defined Function
Rating:
|
Discuss
|
Briefcase
|
838 reads
String Tokenizer with Complex Search
Sample solution to replace string in expressions with multiple delimiters.
Read more...
By
tsaftalov
2008/01/31
|
Source:
SQLServerCentral.com
|
Category:
String Manipulation
Rating:
|
Discuss
|
Briefcase
|
944 reads
Find occurence of any value in database!
Search entire database for occurrence of any text!
Read more...
By
Reddy Software Solutions
2007/12/31
|
Source:
SQLServerCentral.com
|
Category:
Search
Rating:
|
Discuss
|
Briefcase
|
1,934 reads
Split by Row & Field delimitters
Like my tdard split but this will take a string and split it by 2 delimiters
Read more...
By
Reddy Software Solutions
2007/12/28
|
Source:
SQLServerCentral.com
|
Category:
String Manipulation
Rating:
|
Discuss
|
Briefcase
|
968 reads
Function to expand tab characters
A function to replace tab characters with the correct number of spaces to align the text as originally intended.
Read more...
By
Phil Factor
2007/12/14
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
846 reads
XML Workshop XII - Parsing a delimited string
Continuing with his series on XML structures, this article looks at how to split a string up using XQUERY.
Read more...
By
Jacob Sebastian
2007/12/05
|
Source:
SQLServerCentral.com
|
Category:
XML
Rating:
|
Discuss
|
Briefcase
|
3,781 reads
Items 1 to 14 of 14
Most popular
Owning the Spelling Suggestion Feature
To create your own spelling suggestion feature, you need a look-up with correct spellings and misspellings. I walk you through it.
Read more...
By
Bill Nicolich
2008/07/21
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
3,677 reads
SQL String User Function Workbench: part 1
Robyn and Phil go back to basics and hammer out some basic String-handling User Functions in TSQL, based on Python examples. Plenty of sample code, and TSQL programming tricks.
Read more...
By
Additional Articles
2008/04/22
|
Source:
SimpleTalk
|
Category:
T-SQL
Rating:
Rate this
|
Briefcase
|
3,266 reads
XML Workshop XII - Parsing a delimited string
Continuing with his series on XML structures, this article looks at how to split a string up using XQUERY.
Read more...
By
Jacob Sebastian
2007/12/05
|
Source:
SQLServerCentral.com
|
Category:
XML
Rating:
|
Discuss
|
Briefcase
|
3,781 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
