SqlFunctions.StringConvert SqlFunctions.StringConvert SqlFunctions.StringConvert SqlFunctions.StringConvert Method

Definition

Returns character data converted from numeric data.

Overloads

StringConvert(Nullable<Decimal>) StringConvert(Nullable<Decimal>) StringConvert(Nullable<Decimal>) StringConvert(Nullable<Decimal>)

Returns character data converted from numeric data.

StringConvert(Nullable<Double>) StringConvert(Nullable<Double>) StringConvert(Nullable<Double>) StringConvert(Nullable<Double>)

Returns character data converted from numeric data.

StringConvert(Nullable<Decimal>, Nullable<Int32>) StringConvert(Nullable<Decimal>, Nullable<Int32>) StringConvert(Nullable<Decimal>, Nullable<Int32>) StringConvert(Nullable<Decimal>, Nullable<Int32>)

Returns character data converted from numeric data.

StringConvert(Nullable<Double>, Nullable<Int32>) StringConvert(Nullable<Double>, Nullable<Int32>) StringConvert(Nullable<Double>, Nullable<Int32>) StringConvert(Nullable<Double>, Nullable<Int32>)

Returns character data converted from numeric data.

StringConvert(Nullable<Decimal>, Nullable<Int32>, Nullable<Int32>) StringConvert(Nullable<Decimal>, Nullable<Int32>, Nullable<Int32>) StringConvert(Nullable<Decimal>, Nullable<Int32>, Nullable<Int32>) StringConvert(Nullable<Decimal>, Nullable<Int32>, Nullable<Int32>)

Returns character data converted from numeric data.

StringConvert(Nullable<Double>, Nullable<Int32>, Nullable<Int32>) StringConvert(Nullable<Double>, Nullable<Int32>, Nullable<Int32>) StringConvert(Nullable<Double>, Nullable<Int32>, Nullable<Int32>) StringConvert(Nullable<Double>, Nullable<Int32>, Nullable<Int32>)

Returns character data converted from numeric data.

Remarks

You cannot call this function directly. This function can only appear within a LINQ to Entities query.

This function is translated to a corresponding function in the database. For information about the corresponding SQL Server function, see STR (Transact-SQL).

StringConvert(Nullable<Decimal>) StringConvert(Nullable<Decimal>) StringConvert(Nullable<Decimal>) StringConvert(Nullable<Decimal>)

Returns character data converted from numeric data.

public:
 static System::String ^ StringConvert(Nullable<System::Decimal> number);
[System.Data.Objects.DataClasses.EdmFunction("SqlServer", "STR")]
public static string StringConvert (Nullable<decimal> number);
static member StringConvert : Nullable<decimal> -> string
Public Shared Function StringConvert (number As Nullable(Of Decimal)) As String
Parameters
number
Nullable<Decimal>

A numeric expression.

Returns

The input expression converted to a string.

Remarks

You cannot call this function directly. This function can only appear within a LINQ to Entities query.

This function is translated to a corresponding function in the database. For information about the corresponding SQL Server function, see STR (Transact-SQL).

StringConvert(Nullable<Double>) StringConvert(Nullable<Double>) StringConvert(Nullable<Double>) StringConvert(Nullable<Double>)

Returns character data converted from numeric data.

public:
 static System::String ^ StringConvert(Nullable<double> number);
[System.Data.Objects.DataClasses.EdmFunction("SqlServer", "STR")]
public static string StringConvert (Nullable<double> number);
static member StringConvert : Nullable<double> -> string
Public Shared Function StringConvert (number As Nullable(Of Double)) As String
Parameters
number
Nullable<Double>

A numeric expression.

Returns

The numeric input expression converted to a string.

Remarks

You cannot call this function directly. This function can only appear within a LINQ to Entities query.

This function is translated to a corresponding function in the database. For information about the corresponding SQL Server function, see STR (Transact-SQL).

StringConvert(Nullable<Decimal>, Nullable<Int32>) StringConvert(Nullable<Decimal>, Nullable<Int32>) StringConvert(Nullable<Decimal>, Nullable<Int32>) StringConvert(Nullable<Decimal>, Nullable<Int32>)

Returns character data converted from numeric data.

public:
 static System::String ^ StringConvert(Nullable<System::Decimal> number, Nullable<int> length);
[System.Data.Objects.DataClasses.EdmFunction("SqlServer", "STR")]
public static string StringConvert (Nullable<decimal> number, Nullable<int> length);
static member StringConvert : Nullable<decimal> * Nullable<int> -> string
Public Shared Function StringConvert (number As Nullable(Of Decimal), length As Nullable(Of Integer)) As String
Parameters
number
Nullable<Decimal>

A numeric expression.

length
Nullable<Int32>

The total length of the string. This includes decimal point, sign, digits, and spaces. The default is 10.

Returns

The input expression converted to a string.

Remarks

You cannot call this function directly. This function can only appear within a LINQ to Entities query.

This function is translated to a corresponding function in the database. For information about the corresponding SQL Server function, see STR (Transact-SQL).

StringConvert(Nullable<Double>, Nullable<Int32>) StringConvert(Nullable<Double>, Nullable<Int32>) StringConvert(Nullable<Double>, Nullable<Int32>) StringConvert(Nullable<Double>, Nullable<Int32>)

Returns character data converted from numeric data.

public:
 static System::String ^ StringConvert(Nullable<double> number, Nullable<int> length);
[System.Data.Objects.DataClasses.EdmFunction("SqlServer", "STR")]
public static string StringConvert (Nullable<double> number, Nullable<int> length);
static member StringConvert : Nullable<double> * Nullable<int> -> string
Public Shared Function StringConvert (number As Nullable(Of Double), length As Nullable(Of Integer)) As String
Parameters
number
Nullable<Double>

A numeric expression.

length
Nullable<Int32>

The total length of the string. This includes decimal point, sign, digits, and spaces. The default is 10.

Returns

The numeric input expression converted to a string.

Remarks

You cannot call this function directly. This function can only appear within a LINQ to Entities query.

This function is translated to a corresponding function in the database. For information about the corresponding SQL Server function, see STR (Transact-SQL).

StringConvert(Nullable<Decimal>, Nullable<Int32>, Nullable<Int32>) StringConvert(Nullable<Decimal>, Nullable<Int32>, Nullable<Int32>) StringConvert(Nullable<Decimal>, Nullable<Int32>, Nullable<Int32>) StringConvert(Nullable<Decimal>, Nullable<Int32>, Nullable<Int32>)

Returns character data converted from numeric data.

public:
 static System::String ^ StringConvert(Nullable<System::Decimal> number, Nullable<int> length, Nullable<int> decimalArg);
[System.Data.Objects.DataClasses.EdmFunction("SqlServer", "STR")]
public static string StringConvert (Nullable<decimal> number, Nullable<int> length, Nullable<int> decimalArg);
static member StringConvert : Nullable<decimal> * Nullable<int> * Nullable<int> -> string
Public Shared Function StringConvert (number As Nullable(Of Decimal), length As Nullable(Of Integer), decimalArg As Nullable(Of Integer)) As String
Parameters
number
Nullable<Decimal>

A numeric expression.

length
Nullable<Int32>

The total length of the string. This includes decimal point, sign, digits, and spaces. The default is 10.

decimalArg
Nullable<Int32>

The number of places to the right of the decimal point. decimal must be less than or equal to 16. If decimal is more than 16 then the result is truncated to sixteen places to the right of the decimal point.

Returns

The input expression converted to a string.

Remarks

You cannot call this function directly. This function can only appear within a LINQ to Entities query.

This function is translated to a corresponding function in the database. For information about the corresponding SQL Server function, see STR (Transact-SQL).

StringConvert(Nullable<Double>, Nullable<Int32>, Nullable<Int32>) StringConvert(Nullable<Double>, Nullable<Int32>, Nullable<Int32>) StringConvert(Nullable<Double>, Nullable<Int32>, Nullable<Int32>) StringConvert(Nullable<Double>, Nullable<Int32>, Nullable<Int32>)

Returns character data converted from numeric data.

public:
 static System::String ^ StringConvert(Nullable<double> number, Nullable<int> length, Nullable<int> decimalArg);
[System.Data.Objects.DataClasses.EdmFunction("SqlServer", "STR")]
public static string StringConvert (Nullable<double> number, Nullable<int> length, Nullable<int> decimalArg);
static member StringConvert : Nullable<double> * Nullable<int> * Nullable<int> -> string
Public Shared Function StringConvert (number As Nullable(Of Double), length As Nullable(Of Integer), decimalArg As Nullable(Of Integer)) As String
Parameters
number
Nullable<Double>

A numeric expression.

length
Nullable<Int32>

The total length of the string. This includes decimal point, sign, digits, and spaces. The default is 10.

decimalArg
Nullable<Int32>

The number of places to the right of the decimal point. decimal must be less than or equal to 16. If decimal is more than 16 then the result is truncated to sixteen places to the right of the decimal point.

Returns

The numeric input expression converted to a string.

Remarks

You cannot call this function directly. This function can only appear within a LINQ to Entities query.

This function is translated to a corresponding function in the database. For information about the corresponding SQL Server function, see STR (Transact-SQL).

Applies to