SqlFunctions.CharIndex 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 the starting position of one expression found within another expression.
Overloads
| CharIndex(String, String, Nullable<Int64>) |
Returns the starting position of one expression found within another expression. |
| CharIndex(Byte[], Byte[], Nullable<Int64>) |
Returns the starting position of one expression found within another expression. |
| CharIndex(String, String, Nullable<Int32>) |
Returns the starting position of one expression found within another expression. |
| CharIndex(String, String) |
Returns the starting position of one expression found within another expression. |
| CharIndex(Byte[], Byte[]) |
Returns the starting position of one expression found within another expression. |
| CharIndex(Byte[], Byte[], Nullable<Int32>) |
Returns the starting position of one expression found within another expression. |
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 CHARINDEX (Transact-SQL).
CharIndex(String, String, Nullable<Int64>)
Returns the starting position of one expression found within another expression.
public:
static Nullable<long> CharIndex(System::String ^ toSearch, System::String ^ target, Nullable<long> startLocation);[System.Data.Objects.DataClasses.EdmFunction("SqlServer", "CHARINDEX")]
public static long? CharIndex (string toSearch, string target, long? startLocation);[<System.Data.Objects.DataClasses.EdmFunction("SqlServer", "CHARINDEX")>]
static member CharIndex : string * string * Nullable<int64> -> Nullable<int64>Public Shared Function CharIndex (toSearch As String, target As String, startLocation As Nullable(Of Long)) As Nullable(Of Long)Parameters
- toSearch
- String
The string expression to be searched.
- target
- String
The string expression to be found.
Returns
A Nullable<T> of Int64 value that is the starting position of target if it is found in toSearch.
- 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 CHARINDEX (Transact-SQL).
Applies to
CharIndex(Byte[], Byte[], Nullable<Int64>)
Returns the starting position of one expression found within another expression.
public:
static Nullable<long> CharIndex(cli::array <System::Byte> ^ toSearch, cli::array <System::Byte> ^ target, Nullable<long> startLocation);[System.Data.Objects.DataClasses.EdmFunction("SqlServer", "CHARINDEX")]
public static long? CharIndex (byte[] toSearch, byte[] target, long? startLocation);[<System.Data.Objects.DataClasses.EdmFunction("SqlServer", "CHARINDEX")>]
static member CharIndex : byte[] * byte[] * Nullable<int64> -> Nullable<int64>Public Shared Function CharIndex (toSearch As Byte(), target As Byte(), startLocation As Nullable(Of Long)) As Nullable(Of Long)Parameters
- toSearch
- Byte[]
The string expression to be searched.
- target
- Byte[]
The string expression to be found.
Returns
The starting position of target if it is found in toSearch.
- 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 CHARINDEX (Transact-SQL).
Applies to
CharIndex(String, String, Nullable<Int32>)
Returns the starting position of one expression found within another expression.
public:
static Nullable<int> CharIndex(System::String ^ toSearch, System::String ^ target, Nullable<int> startLocation);[System.Data.Objects.DataClasses.EdmFunction("SqlServer", "CHARINDEX")]
public static int? CharIndex (string toSearch, string target, int? startLocation);[<System.Data.Objects.DataClasses.EdmFunction("SqlServer", "CHARINDEX")>]
static member CharIndex : string * string * Nullable<int> -> Nullable<int>Public Shared Function CharIndex (toSearch As String, target As String, startLocation As Nullable(Of Integer)) As Nullable(Of Integer)Parameters
- toSearch
- String
The string expression to be searched.
- target
- String
The string expression to be found.
Returns
The starting position of target if it is found in toSearch.
- 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 CHARINDEX (Transact-SQL).
Applies to
CharIndex(String, String)
Returns the starting position of one expression found within another expression.
public:
static Nullable<int> CharIndex(System::String ^ toSearch, System::String ^ target);[System.Data.Objects.DataClasses.EdmFunction("SqlServer", "CHARINDEX")]
public static int? CharIndex (string toSearch, string target);[<System.Data.Objects.DataClasses.EdmFunction("SqlServer", "CHARINDEX")>]
static member CharIndex : string * string -> Nullable<int>Public Shared Function CharIndex (toSearch As String, target As String) As Nullable(Of Integer)Parameters
- toSearch
- String
The string expression to be searched.
- target
- String
The string expression to be found.
Returns
The starting position of target if it is found in toSearch.
- 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 CHARINDEX (Transact-SQL).
Applies to
CharIndex(Byte[], Byte[])
Returns the starting position of one expression found within another expression.
public:
static Nullable<int> CharIndex(cli::array <System::Byte> ^ toSearch, cli::array <System::Byte> ^ target);[System.Data.Objects.DataClasses.EdmFunction("SqlServer", "CHARINDEX")]
public static int? CharIndex (byte[] toSearch, byte[] target);[<System.Data.Objects.DataClasses.EdmFunction("SqlServer", "CHARINDEX")>]
static member CharIndex : byte[] * byte[] -> Nullable<int>Public Shared Function CharIndex (toSearch As Byte(), target As Byte()) As Nullable(Of Integer)Parameters
- toSearch
- Byte[]
The string expression to be searched.
- target
- Byte[]
The string expression to be found.
Returns
The starting position of target if it is found in toSearch.
- 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 CHARINDEX (Transact-SQL).
Applies to
CharIndex(Byte[], Byte[], Nullable<Int32>)
Returns the starting position of one expression found within another expression.
public:
static Nullable<int> CharIndex(cli::array <System::Byte> ^ toSearch, cli::array <System::Byte> ^ target, Nullable<int> startLocation);[System.Data.Objects.DataClasses.EdmFunction("SqlServer", "CHARINDEX")]
public static int? CharIndex (byte[] toSearch, byte[] target, int? startLocation);[<System.Data.Objects.DataClasses.EdmFunction("SqlServer", "CHARINDEX")>]
static member CharIndex : byte[] * byte[] * Nullable<int> -> Nullable<int>Public Shared Function CharIndex (toSearch As Byte(), target As Byte(), startLocation As Nullable(Of Integer)) As Nullable(Of Integer)Parameters
- toSearch
- Byte[]
The string expression to be searched.
- target
- Byte[]
The string expression to be found.
Returns
The starting position of target if it is found in toSearch.
- 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 CHARINDEX (Transact-SQL).
Applies to
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