Category Archives: SQL Functions

SQL Functions

RIGHT() function in SQL Server

Posted on January 26, 2015 by vivekjohari

SQL Server – RIGHT () function Right():- This function returns the specified number of characters from the Right part of the given character string. Syntax:- Select RIGHT ( character_expression , integer_expression ) For example, the below query will return two characters … Continue reading →

Posted in SQL Basic, SQL Functions, SQL Server | Tagged | 30 Comments

LEFT() function in SQL Server

Posted on January 26, 2015 by vivekjohari

LEFT() function in SQL Server Left() Function  This function returns the specified number of characters from the left part of the given character string. Syntax Select LEFT ( character_expression , integer_expression )For example, the below query will return two characters … Continue reading →

Posted in SQL Basic, SQL Functions, SQL Server | Tagged | 31 Comments

Between function in SQL Server

Posted on January 26, 2015 by vivekjohari

Between function in SQL Server This function is used to select the values within a specified range. These values can be of Int type or Date data type or Text data type. Syntax:- SELECT column_name(s) FROM table_name WHERE column_name BETWEEN … Continue reading →

Posted in SQL Basic, SQL Functions, SQL Server | Tagged | Leave a comment

SQL Server – Convert() function

Posted on January 24, 2015 by vivekjohari

Convert () function in SQL Server Convert () function is used to convert an expression from one data type to another data typeSyntax for CONVERT function CONVERT ( data_type [ ( length ) ] , expression [ , style ] ) Convert functions … Continue reading →

Posted in SQL Basic, SQL Functions, SQL Server | Tagged , | 31 Comments

AVG() function in SQL Server

Posted on August 14, 2014 by vivekjohari

Avg():- This function is used to get the average value of a numeric column Syntax:-       SELECT AVG(column_name) FROM table_name In this article, we are going to use the following table for some examples:- CREATE TABLE [dbo]. [Employee]( [Empid] [Int] … Continue reading →

Posted in SQL Functions, SQL Server | Tagged | 29 Comments

UPPER() function in SQL Server

Posted on August 14, 2014 by vivekjohari

UPPER():- This function is used to convert the value of a column to upper case.  Syntax:    SELECT UPPER(string) OR Select UPPER(Column name) from tablename For example,   SELECT UPPER(‘Vivek’) Result:    VIVEK

Posted in SQL Functions, SQL Server | Tagged | 30 Comments

LEN() function in SQL Server

Posted on August 14, 2014 by vivekjohari

LEN():- This function is used to get the length of the given string value.   Syntax:-     Select len (stringvalue)   For example,     Select len(‘Vivek Johari’)    Result:-    12

Posted in SQL Functions, SQL Server | Tagged | Leave a comment

LOWER() function in SQL Server

Posted on August 14, 2014 by vivekjohari

LOWER():- This function is used to convert the value of a column to lower case  Syntax:-  Select LOWER (string)    or    SELECT LOWER(column_name) FROM table_name For example, SELECT LOWER(‘Vivek Johari’) Result:- vivek johari

Posted in SQL Functions, SQL Server | Tagged | Leave a comment

LTRIM() function in SQL Server

Posted on August 14, 2014 by vivekjohari

LTRIM ():- This function is used to get the string after the removal of leading blank spaces. Syntax:- LTRIM ( character_expression ) For example:- Select LTRIM  (‘  Vivek Johari’) Result:- Vivek Johari (without blank spaces on left side)

Posted in SQL Functions, SQL Server | Tagged | 21 Comments

Substring() function in SQL Server

Posted on August 14, 2014 by vivekjohari

Substring():- This function is used to return the specified number (third argument “len”) of characters from a given string(first argument) from the start position as specified as the second argument. Syntax:-    Select  SUBSTRING ( expression ,start , length ) … Continue reading →

Posted in SQL Functions, SQL Server | Tagged | 31 Comments