2007-03-07 (first published: 2003-06-30)
403 reads
Nagabhushanam Ponnapalli
Initcap Function
INITCAP returns char, with the first letter of each word in uppercase, all other letters in lowercase. Words are delimited by white space or characters that are not alphanumeric.
2006-05-29 (first published: 2003-07-02)
549 reads
Using Built in Functions in User Defined Functions
This short article shows an interesting technique for using the SQL built in functions inside a user defined function (UDF).
2003-08-07
6,090 reads
2003-07-02
562 reads
2003-07-02
273 reads
SUBSTR - SUBSTRING function extension
SUBSTR returns a portion of char, beginning at character @StartPos, @Length characters long. If @StartPos is 0, it is treated as 1. If @StartPos is positive, Oracle counts from the beginning of char to find the first character. If @StartPos is negative, Oracle counts backwards from the end of char.
2003-07-02
242 reads
INSTR Function
INSTR searches string for substring. --> position is an integer indicating the character of string where SQL Server begins the search. -->If position is negative, SQL Server counts and searches backward from the end of string. occurrence is an integer indicating which occurrence of string SQL Server should search for. The value of occurrence must […]
2002-11-12
1,228 reads
Blogs
Welcome to 3Cloud …
By DataOnWheels
A little over a month ago, Pragmatic Works Consulting was a part of a...
Daily Coping 23 Oct 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
One Thousand SQL Saturdays (*ish)
By Steve Jones
This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...
Forums
REST API through SSIS
I want to call (REST) API the "GET" command and assign the return value...
How to reduce physical size of database
I deleted few tables having millions of records, but when see the physical space,...
How to get these description from XML into the table?
I want all these description in different row. TIA Example descriptions 0|Home 1|Office|False...
Ask SSC