SqlFunctions.CharIndex Method

Reference

Definition

Namespace:: System.Data.Entity.SqlServer

Assembly:: EntityFramework.SqlServer.dll

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

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.

CharIndex(String, String, Nullable<Int64>)

Returns the starting position of one expression found within another expression.

[System.Data.Entity.DbFunction("SqlServer", "CHARINDEX")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="startLocation")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="toSearch")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="toFind")]
public static Nullable<long> CharIndex (string toFind, string toSearch, Nullable<long> startLocation);

static member CharIndex : string * string * Nullable<int64> -> Nullable<int64>

Public Shared Function CharIndex (toFind As String, toSearch As String, startLocation As Nullable(Of Long)) As Nullable(Of Long)

Parameters

toFind: String

The string expression to be found.

toSearch: String

The string expression to be searched.

startLocation: Nullable<Int64>

The character position in toSearch where searching begins.

Returns

Nullable<Int64>

A Nullable<T> of Int64 value that is the starting position of toFind if it is found in toSearch .

Attributes: DbFunctionAttribute SuppressMessageAttribute

Applies to

CharIndex(Byte[], Byte[], Nullable<Int64>)

Returns the starting position of one expression found within another expression.

[System.Data.Entity.DbFunction("SqlServer", "CHARINDEX")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="toSearch")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="startLocation")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="toFind")]
public static Nullable<long> CharIndex (byte[] toFind, byte[] toSearch, Nullable<long> startLocation);

static member CharIndex : byte[] * byte[] * Nullable<int64> -> Nullable<int64>

Public Shared Function CharIndex (toFind As Byte(), toSearch As Byte(), startLocation As Nullable(Of Long)) As Nullable(Of Long)

Parameters

toFind: Byte[]

The string expression to be found.

toSearch: Byte[]

The string expression to be searched.

startLocation: Nullable<Int64>

The character position in toSearch where searching begins.

Returns

Nullable<Int64>

The starting position of toFind if it is found in toSearch .

Attributes: DbFunctionAttribute SuppressMessageAttribute

Applies to

CharIndex(String, String, Nullable<Int32>)

Returns the starting position of one expression found within another expression.

[System.Data.Entity.DbFunction("SqlServer", "CHARINDEX")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="toFind")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="toSearch")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="startLocation")]
public static Nullable<int> CharIndex (string toFind, string toSearch, Nullable<int> startLocation);

static member CharIndex : string * string * Nullable<int> -> Nullable<int>

Public Shared Function CharIndex (toFind As String, toSearch As String, startLocation As Nullable(Of Integer)) As Nullable(Of Integer)

Parameters

toFind: String

The string expression to be found.

toSearch: String

The string expression to be searched.

startLocation: Nullable<Int32>

The character position in toSearch where searching begins.

Returns

Nullable<Int32>

The starting position of toFind if it is found in toSearch .

Attributes: DbFunctionAttribute SuppressMessageAttribute

Applies to

CharIndex(String, String)

Returns the starting position of one expression found within another expression.

[System.Data.Entity.DbFunction("SqlServer", "CHARINDEX")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="toSearch")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="toFind")]
public static Nullable<int> CharIndex (string toFind, string toSearch);

static member CharIndex : string * string -> Nullable<int>

Public Shared Function CharIndex (toFind As String, toSearch As String) As Nullable(Of Integer)

Parameters

toFind: String

The string expression to be found.

toSearch: String

The string expression to be searched.

Returns

Nullable<Int32>

The starting position of toFind if it is found in toSearch .

Attributes: DbFunctionAttribute SuppressMessageAttribute

Applies to

CharIndex(Byte[], Byte[])

Returns the starting position of one expression found within another expression.

[System.Data.Entity.DbFunction("SqlServer", "CHARINDEX")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="toFind")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="toSearch")]
public static Nullable<int> CharIndex (byte[] toFind, byte[] toSearch);

static member CharIndex : byte[] * byte[] -> Nullable<int>

Public Shared Function CharIndex (toFind As Byte(), toSearch As Byte()) As Nullable(Of Integer)

Parameters

toFind: Byte[]

The string expression to be found.

toSearch: Byte[]

The string expression to be searched.

Returns

Nullable<Int32>

The starting position of toFind if it is found in toSearch .

Attributes: DbFunctionAttribute SuppressMessageAttribute

Applies to

CharIndex(Byte[], Byte[], Nullable<Int32>)

Returns the starting position of one expression found within another expression.

[System.Data.Entity.DbFunction("SqlServer", "CHARINDEX")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="toSearch")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="startLocation")]
[System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA1801:ReviewUnusedParameters", MessageId="toFind")]
public static Nullable<int> CharIndex (byte[] toFind, byte[] toSearch, Nullable<int> startLocation);

static member CharIndex : byte[] * byte[] * Nullable<int> -> Nullable<int>

Public Shared Function CharIndex (toFind As Byte(), toSearch As Byte(), startLocation As Nullable(Of Integer)) As Nullable(Of Integer)

Parameters

toFind: Byte[]

The string expression to be found.

toSearch: Byte[]

The string expression to be searched.

startLocation: Nullable<Int32>

The character position in toSearch where searching begins.

Returns

Nullable<Int32>

The starting position of toFind if it is found in toSearch .

Attributes: DbFunctionAttribute SuppressMessageAttribute

Applies to

Share via

SqlFunctions.CharIndex Method

Definition

Overloads

CharIndex(String, String, Nullable<Int64>)

Parameters

Returns

Applies to

CharIndex(Byte[], Byte[], Nullable<Int64>)

Parameters

Returns

Applies to

CharIndex(String, String, Nullable<Int32>)

Parameters

Returns

Applies to

CharIndex(String, String)

Parameters

Returns

Applies to

CharIndex(Byte[], Byte[])

Parameters

Returns

Applies to

CharIndex(Byte[], Byte[], Nullable<Int32>)

Parameters

Returns

Applies to

Additional resources