Edit

Share via


SqlFunctions.StringConvert Method

Definition

Returns character data converted from numeric data.

Overloads

StringConvert(Nullable<Decimal>)

Returns character data converted from numeric data.

StringConvert(Nullable<Double>)

Returns character data converted from numeric data.

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

Returns character data converted from numeric data.

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

Returns character data converted from numeric data.

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

Returns character data converted from numeric data.

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>)

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 (decimal? number);
[<System.Data.Objects.DataClasses.EdmFunction("SqlServer", "STR")>]
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.

Attributes

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

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 (double? number);
[<System.Data.Objects.DataClasses.EdmFunction("SqlServer", "STR")>]
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.

Attributes

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

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 (decimal? number, int? length);
[<System.Data.Objects.DataClasses.EdmFunction("SqlServer", "STR")>]
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.

Attributes

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

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 (double? number, int? length);
[<System.Data.Objects.DataClasses.EdmFunction("SqlServer", "STR")>]
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.

Attributes

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

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 (decimal? number, int? length, int? decimalArg);
[<System.Data.Objects.DataClasses.EdmFunction("SqlServer", "STR")>]
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. decimalArg must be less than or equal to 16. If decimalArg 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.

Attributes

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

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 (double? number, int? length, int? decimalArg);
[<System.Data.Objects.DataClasses.EdmFunction("SqlServer", "STR")>]
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. decimalArg must be less than or equal to 16. If decimalArg 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.

Attributes

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