| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 A relational technique to strip the HTML tags out of a string | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 18276 since
7/29/2000 9:56:49 PM | Unrated
|
| |
A relational technique to strip the HTML tags out of a string. This solution demonstrates how to use simple tables & search functions effectively in SQL Server to solve procedural / iterative problems. |
| |
| |
| |
|
A REPLACE function for a TEXT field | SQL Server 7.0 | Intermediate /
J Shortland | 36151 since
11/29/2001 6:26:04 PM |
By 7 Users
|
| |
Generically, the Replace function in SQL Server
doesn't support replacing a particular string
with another within a TEXT field; this can. |
| |
| |
| |
|
A REPLACE function for a TEXT field as a Stored Procedure | SQL Server 7.0 | Intermediate /
J Shortland | 23859 since
1/20/2002 4:12:18 PM | Unrated
|
| |
This is a Stored Procedure version of my original submission: A REPLACE function for a TEXT field
http://www.pscode.com/vb/scripts/ShowCode.asp?txtCodeId=367&lngWId=5 |
| |
| |
| |
|
Capitalize First Letter | SQL Server 2000 | Intermediate /
Adonis Villanueva | 19799 since
4/18/2003 5:09:35 PM |
By 1 Users
|
| |
This is a User Defined Function (UDF) that will capitalize the first letter of a character after a space. It will also lowercase all capitalized words. This will only capitalize the first letter after the any space. Example: 'A CAT RAN DOWN' --> 'A Cat Ra ...(description truncated) |
| |
| |
| |
|
Case Sensitive and Insensitive | SQL Server 2000 | Beginner /
CodeBased | 11858 since
11/18/2004 10:02:16 AM | Unrated
|
| |
see below |
| |
| |
| |
|
Check only for numeric digits without using a loop | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 13548 since
7/29/2000 9:55:41 PM |
By 2 Users
|
| |
The ISNUMERIC function in SQL60/65/70 checks for decimal & integer values. Hence characters like D, E are valid float representations & similarly ','. This is a simple logic that can check only for numeric digits without using a loop of any kind |
| |
| |
| |
|
Comma-separated string via COALESCE | SQL Server 7.0, SQL Server 6.5 and earlier | Intermediate /
Umachandar | 16592 since
7/29/2000 9:53:39 PM |
By 1 Users
|
| |
Concatenating several column values as a comma-separated string is a often encountered scenario. This method shows one way to do this using COALESCE function. |
| |
| |
| |
|
Concatenate address fields for display | SQL Server 2000 | Beginner /
Jonathan Spinks | 10390 since
9/13/2006 8:10:11 AM | Unrated
|
| |
When displaying address information from multiple fields in your database generally each field is separated by a carriage return line feed. If one of the values is null or an empty field then you don’t want to display the empty lines. This little fu ...(description truncated) |
| |
| |
| |
|
Concatenate Strings | SQL Server 7.0 | Intermediate /
Dumitru Radu | 14622 since
7/13/2001 12:24:42 PM | Unrated
|
| |
Construct ntext field which is comming like a description field for E-Commerce Products Table for Mas90 users. (ScreenShot) |
| |
| |
| |
|
Concatenate Strings using Cursor | SQL Server 7.0 | Intermediate /
Dumitru Radu | 18585 since
7/20/2001 10:24:28 AM |
By 6 Users
4 Excellent Ratings
|
| |
Construct a query with a long string field which contains concatenated selections from initial table.(ScreenShot) |
| |
(ScreenShot)
(ScreenShot)
