SqlFunctions.StringConvert Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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> -> stringPublic Shared Function StringConvert (number As Nullable(Of Decimal)) As StringParameters
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> -> stringPublic Shared Function StringConvert (number As Nullable(Of Double)) As StringParameters
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> -> stringPublic Shared Function StringConvert (number As Nullable(Of Decimal), length As Nullable(Of Integer)) As StringParameters
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> -> stringPublic Shared Function StringConvert (number As Nullable(Of Double), length As Nullable(Of Integer)) As StringParameters
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> -> stringPublic Shared Function StringConvert (number As Nullable(Of Decimal), length As Nullable(Of Integer), decimalArg As Nullable(Of Integer)) As StringParameters
The total length of the string. This includes decimal point, sign, digits, and spaces. The default is 10.
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> -> stringPublic Shared Function StringConvert (number As Nullable(Of Double), length As Nullable(Of Integer), decimalArg As Nullable(Of Integer)) As StringParameters
The total length of the string. This includes decimal point, sign, digits, and spaces. The default is 10.
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).
