SQL Server TRIM() Function

STR() Function in SQL Server

Last Updated : 24 Sep, 2020

The STR() function converts a numeric value to a character value.

Syntax :

STR(float_expression [, length [, decimal]])

Parameter : This method accepts three parameters as mentioned above and described below :

float_expression : It is a numeric expression that evaluates to an approximate number with a decimal point.
length : It is the total length of the returned string.
decimal : It is the number of places to the right of the decimal point.

Returns : It returns a number as a string.

Example-1 :

SELECT STR(246.573, 6, 2);

Output :

246.57

Example-2 :

SELECT STR(246.573, 3, 3);

Output :

Example-3 :

SELECT STR(246.573, 2, 2);

Output :

**

Example-4 :

SELECT STR(246.573, 8, 4);

Output :

246.5730

SQL Server TRIM() Function

sanjoy_62

Improve

Article Tags :

Similar Reads

SQRT() Function in SQL Server

SQRT() function : This function in SQL Server is used to return the square root of a specified positive number. For example, if the specified number is 81, this function will return 9. Features : This function is used to find the square root of a given number. This function accepts only positive num

SUM() Function in SQL Server

The SUM() function in SQL Server is an essential aggregate function used to calculate the total sum of values in a numeric column. It aggregates data by summing up all values in the specified column for the rows that match the criteria of the query. In this article, We will learn about SUM() Functio

SQUARE() Function in SQL Server

SQUARE() function : This function in SQL Server is used to return the square of a specified number. For example, if the specified number is 9, this function will return 81 as output. Features : This function is used to square a given number. This function accepts both that is positive and negative n

YEAR() Function in SQL Server

The YEAR() function in SQL Server is a powerful tool designed to extract the year component from a given date or datetime expression. It allows users to isolate the year as an integer value and facilitating various date-related operations and analyses. In this article, We will learn about the YEAR()

SQL Server TRIM() Function

The SQL Server TRIM() function omits the space character or additional stated characters from the beginning or the end of a specified string. TRIM in SQL ServerThe TRIM function in SQL Server is used to remove leading and trailing spaces from a string. Itâ€™s particularly useful for manipulating and c

SYSTEM_USER() Function in SQL Server

SYSTEM_USER() function :This function in SQL Server is used to return the current user's login name.Features : This function is used to find the current user's login name.This function comes under Advanced Functions.This function doesn't accept any parameter. Syntax : SYSTEM_USER; Parameter :This me

TRANSLATE() Function in SQL Server

TRANSLATE() function : This function in SQL Server is used to return the translated string of the string stated in the first argument of this function, when the characters stated in the characters argument of the above function are converted into the characters stated in the last argument i.e, trans

SQL Server LEN() Function

SQL SERVER LEN() function calculates the number of characters of an input string, excluding the trailing spaces. LEN() Function in SQL ServerThe LEN function in the SQL Server fetches the number of characters in a string. It counts the preceding spaces but not the trailing spaces. For eg, 'SQL SERVE

PI() Function in SQL Server

PI() function : This function in SQL Server is used to return the constant float value of math Pi. The default number of decimal places displayed is seven, but SQL Server uses the full double-precision value internally. Features : This function is used to get the value of pi.This function does not a

USER_NAME() Function in SQL Server

USER_NAME() : This function in SQL Server is used to return the username of the database that is based on the id stated. Features : This function is used to find the username of the database used.This function comes under Advanced Functions.This function accepts only one parameter i.e, id number.Thi