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,093 reads
2003-07-02
562 reads
2003-07-02
279 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,230 reads
Blogs
Daily Coping 27 Nov 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 26 Nov 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Azure SQL Database – Greatest and Least TSQL
By Arun Sirpal
Being in the cloud does have many benefits, from lower administration to fast scaling...
Forums
Tlog migration
Hi Expert, In tlog migration, from 1 server to another where there is no...
RegisterAllProvidersIP = 0 and timeout in failover
Good morning all , I have an alwayson instance with a multisubnet listener I...
Tempdb increasing crazily
These days, the Tempdb of my one's SQL server increases crazily, sometimes only abount...
Ask SSC