SQL Server Functions : SQL Server functions has many built-in functions. This reference contains the string, numeric, date, conversion, and advanced functions in SQL Server.<\/p>\n

SQL Server String Functions<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Function<\/strong><\/td>\n	Description<\/strong><\/td>\n<\/tr>\n
ASCII<\/td>\n	Returns the number code that represents the specific character<\/td>\n<\/tr>\n
CHAR<\/td>\n	Returns the ASCII character based on the number code<\/td>\n<\/tr>\n
CHARINDEX<\/td>\n	Returns the location of a substring in a string<\/td>\n<\/tr>\n
CONCAT<\/td>\n	Concatenates two or more strings together<\/td>\n<\/tr>\n
Concat with +<\/td>\n	Concatenates two or more strings together<\/td>\n<\/tr>\n
DATALENGTH<\/td>\n	Returns the length of an expression (in bytes)<\/td>\n<\/tr>\n
LEFT<\/td>\n	Extracts a substring from a string (starting from left)<\/td>\n<\/tr>\n
LEN<\/td>\n	Returns the length of the specified string<\/td>\n<\/tr>\n
LOWER<\/td>\n	Converts a string to lower-case<\/td>\n<\/tr>\n
LTRIM<\/td>\n	Removes leading spaces from a string<\/td>\n<\/tr>\n
NCHAR<\/td>\n	Returns the Unicode character based on the number code<\/td>\n<\/tr>\n
PATINDEX<\/td>\n	Returns the location of a pattern in a string<\/td>\n<\/tr>\n
REPLACE<\/td>\n	Replaces a sequence of characters in a string with another set of characters<\/td>\n<\/tr>\n
RIGHT<\/td>\n	Extracts a substring from a string (starting from right)<\/td>\n<\/tr>\n
RTRIM<\/td>\n	Removes trailing spaces from a string<\/td>\n<\/tr>\n
SPACE<\/td>\n	Returns a string with a specified number of spaces<\/td>\n<\/tr>\n
STR<\/td>\n	Returns a string representation of a number<\/td>\n<\/tr>\n
STUFF<\/td>\n	Deletes a sequence of characters from a string and then inserts another sequence of characters into the string, starting at a specified position<\/td>\n<\/tr>\n
SUBSTRING<\/td>\n	Extracts a substring from a string<\/td>\n<\/tr>\n
UPPER<\/td>\n	Converts a string to upper-case<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n  <\/p>\n SQL Server Numeric Functions<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n Function<\/strong><\/td>\n Description<\/strong><\/td>\n<\/tr>\n ABS<\/td>\n Returns the absolute value of a number<\/td>\n<\/tr>\n AVG<\/td>\n Returns the average value of an expression<\/td>\n<\/tr>\n CEILING<\/td>\n Returns the smallest integer value that is greater than or equal to a number<\/td>\n<\/tr>\n COUNT<\/td>\n Returns the count of an expression<\/td>\n<\/tr>\n FLOOR<\/td>\n Returns the largest integer value that is equal to or less than a number<\/td>\n<\/tr>\n MAX<\/td>\n Returns the maximum value of an expression<\/td>\n<\/tr>\n MIN<\/td>\n Returns the minimum value of an expression<\/td>\n<\/tr>\n RAND<\/td>\n Returns a random number or a random number within a range<\/td>\n<\/tr>\n ROUND<\/td>\n Returns a number rounded to a certain number of decimal places<\/td>\n<\/tr>\n SIGN<\/td>\n Returns a value indicating the sign of a number<\/td>\n<\/tr>\n SUM<\/td>\n Returns the summed value of an expression<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n  <\/p>\n SQL Server Date Functions<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n\n Function<\/strong><\/td>\n Description<\/strong><\/td>\n<\/tr>\n CURRENT_TIMESTAMP<\/td>\n Returns the current date and time<\/td>\n<\/tr>\n DATEADD<\/td>\n Returns a date after a certain time\/date interval has been added<\/td>\n<\/tr>\n DATEDIFF<\/td>\n Returns the difference between two date values, based on the interval specified<\/td>\n<\/tr>\n DATENAME<\/td>\n Returns a specified part of a given date, as a string value<\/td>\n<\/tr>\n DATEPART<\/td>\n Returns a specified part of a given date, as an integer value<\/td>\n<\/tr>\n DAY<\/td>\n Returns the day of the month (from 1 to 31) for a given date<\/td>\n<\/tr>\n GETDATE<\/td>\n Returns the current date and time<\/td>\n<\/tr>\n GETUTCDATE<\/td>\n Returns the current UTC date and time<\/td>\n<\/tr>\n MONTH<\/td>\n Returns the month (from 1 to 12) for a given date<\/td>\n<\/tr>\n YEAR<\/td>\n Returns the year (as a four-digit number) for a given date<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n  <\/p>\n SQL Server Conversion Functions<\/h2>\n\n\n\n\n\n Function<\/strong><\/td>\n Description<\/strong><\/td>\n<\/tr>\n CAST<\/td>\n Converts an expression from one data type to another<\/td>\n<\/tr>\n CONVERT<\/td>\n Converts an expression from one data type to another<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n  <\/p>\n SQL Server Advanced Functions<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n\n Function<\/strong><\/td>\n Description<\/strong><\/td>\n<\/tr>\n COALESCE<\/td>\n Returns the first non-null expression in a list<\/td>\n<\/tr>\n CURRENT_USER<\/td>\n Returns the name of the current user in the SQL Server database<\/td>\n<\/tr>\n ISDATE<\/td>\n Returns 1 if the expression is a valid date, otherwise 0<\/td>\n<\/tr>\n ISNULL<\/td>\n Lets you return an alternative value when an expression is NULL<\/td>\n<\/tr>\n ISNUMERIC<\/td>\n Returns 1 if the expression is a valid number, otherwise 0<\/td>\n<\/tr>\n NULLIF<\/td>\n Compares two expressions<\/td>\n<\/tr>\n SESSION_USER<\/td>\n Returns the user name of the current session in the SQL Server database<\/td>\n<\/tr>\n SESSIONPROPERTY<\/td>\n Returns the setting for a specified option of a session<\/td>\n<\/tr>\n SYSTEM_USER<\/td>\n Returns the login name information for the current user in the SQL Server database<\/td>\n<\/tr>\n USER_NAME<\/td>\n Returns the user name in the SQL Server database<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n  <\/p>\n","protected":false},"excerpt":{"rendered":" SQL Server Functions : SQL Server functions has many built-in functions. This reference contains the string, numeric, date, conversion, and advanced functions in SQL Server.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[386],"tags":[520,521],"class_list":["post-4391","post","type-post","status-publish","format-standard","hentry","category-sql","tag-sql-server-function","tag-sql-server-functions"],"_links":{"self":[{"href":"https:\/\/iteducation.vivegroups.com\/wp-json\/wp\/v2\/posts\/4391","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/iteducation.vivegroups.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/iteducation.vivegroups.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/iteducation.vivegroups.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/iteducation.vivegroups.com\/wp-json\/wp\/v2\/comments?post=4391"}],"version-history":[{"count":1,"href":"https:\/\/iteducation.vivegroups.com\/wp-json\/wp\/v2\/posts\/4391\/revisions"}],"predecessor-version":[{"id":13217,"href":"https:\/\/iteducation.vivegroups.com\/wp-json\/wp\/v2\/posts\/4391\/revisions\/13217"}],"wp:attachment":[{"href":"https:\/\/iteducation.vivegroups.com\/wp-json\/wp\/v2\/media?parent=4391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/iteducation.vivegroups.com\/wp-json\/wp\/v2\/categories?post=4391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/iteducation.vivegroups.com\/wp-json\/wp\/v2\/tags?post=4391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}