31/01/2026, 10:19 SQL Server Functions

 Tutorials  References  Exercises  Get Certified Sign In

HTML
 CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO [Link] C

SQL Server Functions

❮ Previous Next ❯

SQL Server has many built-in functions.

This reference contains string, numeric, date, conversion, and some advanced functions in
SQL Server.

SQL Server String Functions

Function Description

ASCII Returns the ASCII value for the specific character

CHAR Returns the character based on the ASCII code

CHARINDEX Returns the position of a substring in a string

CONCAT Adds two or more strings together

Concat with + Adds two or more strings together

[Link] 1/10
31/01/2026, 10:19 SQL Server Functions

CONCAT_WS
Tutorials  Adds two or more
References strings
Exercises  together with a separator
Get Certified Sign In

DATALENGTH Returns the number of bytes used to represent an expression

HTML
 CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO [Link] C

DIFFERENCE Compares two SOUNDEX values, and returns an integer value

FORMAT Formats a value with the specified format

LEFT Extracts a number of characters from a string (starting from left)

LEN Returns the length of a string

LOWER Converts a string to lower-case

LTRIM Removes leading spaces from a string

NCHAR Returns the Unicode character based on the number code

PATINDEX Returns the position of a pattern in a string

QUOTENAME Returns a Unicode string with delimiters added to make the string a
valid SQL Server delimited identifier

REPLACE Replaces all occurrences of a substring within a string, with a new

substring

REPLICATE Repeats a string a specified number of times

REVERSE Reverses a string and returns the result

RIGHT Extracts a number of characters from a string (starting from right)

RTRIM Removes trailing spaces from a string

SOUNDEX Returns a four-character code to evaluate the similarity of two strings

SPACE Returns a string of the specified number of space characters

STR Returns a number as string

STUFF Deletes a part of a string and then inserts another part into the
string, starting at a specified position

SUBSTRING Extracts some characters from a string

[Link] 2/10
31/01/2026, 10:19 SQL Server Functions

TRANSLATE
Tutorials  Returns the
References  string from the first argument after
Exercises Get the characters Sign In
Certified
specified in the second argument are translated into the characters
HTML
 CSS specified
JAVASCRIPT in the PYTHON
SQL third argument.
JAVA PHP HOW TO [Link] C

TRIM Removes leading and trailing spaces (or other specified characters)
from a string

UNICODE Returns the Unicode value for the first character of the input
expression

UPPER Converts a string to upper-case

ADVERTISEMENT

REMOVE ADS

SQL Server Math/Numeric Functions

Function Description

ABS Returns the absolute value of a number

ACOS Returns the arc cosine of a number

ASIN Returns the arc sine of a number

[Link] 3/10
31/01/2026, 10:19 SQL Server Functions

ATAN Tutorials  Returns the

References  arcExercises
tangentof a number Get Certified Sign In

ATN2 Returns the arc tangent of two numbers

HTML
 CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO [Link] C

AVG Returns the average value of an expression

CEILING Returns the smallest integer value that is >= a number

COUNT Returns the number of records returned by a select query

COS Returns the cosine of a number

COT Returns the cotangent of a number

DEGREES Converts a value in radians to degrees

EXP Returns e raised to the power of a specified number

FLOOR Returns the largest integer value that is <= to a number

LOG Returns the natural logarithm of a number, or the logarithm of a

number to a specified base

LOG10 Returns the natural logarithm of a number to base 10

MAX Returns the maximum value in a set of values

MIN Returns the minimum value in a set of values

PI Returns the value of PI

POWER Returns the value of a number raised to the power of another

number

RADIANS Converts a degree value into radians

RAND Returns a random number

ROUND Rounds a number to a specified number of decimal places

SIGN Returns the sign of a number

SIN Returns the sine of a number

SQRT Returns the square root of a number

[Link] 4/10
31/01/2026, 10:19 SQL Server Functions

SQUARETutorials  Returns the

References  square of a number
Exercises Get Certified Sign In

SUM Calculates the sum of a set of values

HTML
 CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO [Link] C

TAN Returns the tangent of a number

SQL Server Date Functions

Function Description

CURRENT_TIMESTAMP Returns the current date and time

DATEADD Adds a time/date interval to a date and then returns the date

DATEDIFF Returns the difference between two dates

DATEFROMPARTS Returns a date from the specified parts (year, month, and day
values)

DATENAME Returns a specified part of a date (as string)

DATEPART Returns a specified part of a date (as integer)

DAY Returns the day of the month for a specified date

GETDATE Returns the current database system date and time

GETUTCDATE Returns the current database system UTC date and time

ISDATE Checks an expression and returns 1 if it is a valid date, otherwise 0

MONTH Returns the month part for a specified date (a number from 1 to
12)

SYSDATETIME Returns the date and time of the SQL Server

YEAR Returns the year part for a specified date

SQL Server Advanced Functions

[Link] 5/10
31/01/2026, 10:19 SQL Server Functions

Function
Tutorials  Description
References  Exercises  Get Certified Sign In

CAST Converts a value (of any type) into a specified datatype

HTML
 CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO [Link] C

COALESCE Returns the first non-null value in a list

CONVERT Converts a value (of any type) into a specified datatype

CURRENT_USER Returns the name of the current user in the SQL Server database

IIF Returns a value if a condition is TRUE, or another value if a condition

is FALSE

ISNULL Return a specified value if the expression is NULL, otherwise return

the expression

ISNUMERIC Tests whether an expression is numeric

NULLIF Returns NULL if two expressions are equal

SESSION_USER Returns the name of the current user in the SQL Server database

SESSIONPROPERTY Returns the session settings for a specified option

SYSTEM_USER Returns the login name for the current user

USER_NAME Returns the database user name based on the specified id

❮ Previous Sign in to track progress Next ❯

[Link] 6/10
31/01/2026, 10:19 SQL Server Functions

 Tutorials  References  Exercises  Get Certified Sign In

HTML
 CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO [Link] C

COLOR PICKER

 

REMOVE ADS

[Link] 7/10
31/01/2026, 10:19 SQL Server Functions

Python - Variable Names - [Link]

 Tutorials  References  Exercises  Get Certified Sign In

HTML
 CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO [Link] C

[Link] 8/10
31/01/2026, 10:19 SQL Server Functions

 Tutorials  References  Exercises  Get Certified Sign In

HTML
 CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO [Link] C

-->
 PLUS SPACES

GET CERTIFIED FOR TEACHERS

BOOTCAMPS CONTACT US

Top Tutorials
HTML Tutorial
CSS Tutorial
JavaScript Tutorial
How To Tutorial
SQL Tutorial
Python Tutorial
[Link] Tutorial
Bootstrap Tutorial
PHP Tutorial
Java Tutorial
C++ Tutorial
jQuery Tutorial

Top References
HTML Reference
CSS Reference
JavaScript Reference
SQL Reference
Python Reference
[Link] Reference
Bootstrap Reference
PHP Reference
HTML Colors
Java Reference
AngularJS Reference
jQuery Reference

[Link] 9/10
31/01/2026, 10:19 SQL Server Functions

Top Examples Get Certified

 Tutorials  References  Exercises  Get Certified Sign In
HTML Examples HTML Certificate
HTML
 CSS CSS Examples SQL
JAVASCRIPT PYTHON JAVA PHP CSSHOW Certificate
TO [Link] C
JavaScript Examples JavaScript Certificate
How To Examples Front End Certificate
SQL Examples SQL Certificate
Python Examples Python Certificate
[Link] Examples PHP Certificate
Bootstrap Examples jQuery Certificate
PHP Examples Java Certificate
Java Examples C++ Certificate
XML Examples C# Certificate
jQuery Examples XML Certificate

    

FORUM ABOUT ACADEMY

W3Schools is optimized for learning and training. Examples might be simplified to improve reading and
learning.
Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full
correctness
of all content. While using W3Schools, you agree to have read and accepted our terms of use, cookies and
privacy policy.

Copyright 1999-2026 by Refsnes Data. All Rights Reserved. W3Schools is Powered by [Link].

[Link] 10/10