SqlFunctions.IsNumeric(String) Method

Definition

Namespace:

System.Data.Objects.SqlClient

Assembly:

System.Data.Entity.dll

Indicates whether the input value is a valid numeric type.

public:
 static Nullable<int> IsNumeric(System::String ^ arg);

[System.Data.Objects.DataClasses.EdmFunction("SqlServer", "ISNUMERIC")]
public static int? IsNumeric (string arg);

[<System.Data.Objects.DataClasses.EdmFunction("SqlServer", "ISNUMERIC")>]
static member IsNumeric : string -> Nullable<int>

Public Shared Function IsNumeric (arg As String) As Nullable(Of Integer)

Parameters

arg

String

A string expression.

Returns

Nullable<Int32>

1 if the input expression is a valid numeric data type; otherwise, 0.

Attributes

EdmFunctionAttribute

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 ISNUMERIC (Transact-SQL).