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.
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. |
StringConvert(Nullable<Decimal>)
Returns character data converted from numeric data.
[System.Data.Entity.DbFunction("SqlServer", "STR")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="number")]
public static string StringConvert (Nullable<decimal> number);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
Applies to
StringConvert(Nullable<Double>)
Returns character data converted from numeric data.
[System.Data.Entity.DbFunction("SqlServer", "STR")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="number")]
public static string StringConvert (Nullable<double> number);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
Applies to
StringConvert(Nullable<Decimal>, Nullable<Int32>)
Returns character data converted from numeric data.
[System.Data.Entity.DbFunction("SqlServer", "STR")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="number")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="length")]
public static string StringConvert (Nullable<decimal> number, Nullable<int> length);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
Applies to
StringConvert(Nullable<Double>, Nullable<Int32>)
Returns character data converted from numeric data.
[System.Data.Entity.DbFunction("SqlServer", "STR")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="number")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="length")]
public static string StringConvert (Nullable<double> number, Nullable<int> length);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
Applies to
StringConvert(Nullable<Decimal>, Nullable<Int32>, Nullable<Int32>)
Returns character data converted from numeric data.
[System.Data.Entity.DbFunction("SqlServer", "STR")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="number")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="decimalArg")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="length")]
public static string StringConvert (Nullable<decimal> number, Nullable<int> length, Nullable<int> decimalArg);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. 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.
- Attributes
Applies to
StringConvert(Nullable<Double>, Nullable<Int32>, Nullable<Int32>)
Returns character data converted from numeric data.
[System.Data.Entity.DbFunction("SqlServer", "STR")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="number")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="length")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="decimalArg")]
public static string StringConvert (Nullable<double> number, Nullable<int> length, Nullable<int> decimalArg);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. 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.
- Attributes
Applies to
Entity Framework
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for