SQL Server Common functions

LEN (String) returns the length of the character in this string.

ISNULL (Check,return) null value function. Checks if check is null and returns the value of return if null.

DATEADD (unit,duration,date) returns this new datetime value by adding or subtracting a period of time from the specified date. Unit units (Year,day ...), duration--interval length (can be negative), date to be modified.

SUBSTRING (str,index,length) intercepts the string method. STR: The string to be intercepted; index: from which to start interception; Length: how long to intercept.

ASCII (str) Gets the ASCII value of Str.

CHARINDEX (CH,STR) returns the position of the first occurrence of ch in str.

SQL Server Common functions