SqlFunctions.StringConvert SqlFunctions.StringConvert SqlFunctions.StringConvert Method

Definition

Overloads

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

Returns character data converted from numeric data.

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

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

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

Returns character data converted from numeric data.

StringConvert(Nullable<Decimal>) StringConvert(Nullable<Decimal>) 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> -> 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.

StringConvert(Nullable<Double>) StringConvert(Nullable<Double>) 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> -> 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.

StringConvert(Nullable<Decimal>, Nullable<Int32>) StringConvert(Nullable<Decimal>, Nullable<Int32>) 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> -> 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.

StringConvert(Nullable<Double>, Nullable<Int32>) StringConvert(Nullable<Double>, Nullable<Int32>) 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> -> 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.

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.

[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> -> 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.

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.

[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> -> 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.

Applies to