2007-03-07 (first published: 2003-06-30)
407 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)
574 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,150 reads
2003-07-02
575 reads
2003-07-02
350 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
245 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,288 reads
Blogs
Daily Coping 20 May 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 19 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Running dynamic SQL in a different database
This is one of those things that on hindsight was a stupid problem, but...
Forums
min and max startdate
Hi Expert, I wanted to calculate max date for prodstatus =5 - min date...
Azure DE Interview scenario/case questions
Hello guys, I am preparing for Azure DE positions with Data Factory, Databricks, Synapse....
MS SQL Server 2012 question regarding SSIS
OK so I have a customer with a hosted website with eCommerce options. Essentially...
Ask SSC