Skip to main content

Sql CharIndex Function

The CHARINDEX  function returns the starting position of the specified expression in a character string.
Example:
Search for "t" in string "DotNetReceipe", and return position:
SELECT CHARINDEX('t', 'DotNetReceipe') AS Position;
Labels:

Comments

Post a Comment

Popular posts from this blog

List Controls: List Box and Drop Downlist

ASP.Net provides the controls: drop-down list, list box, radio button list, check box list and bulleted list. These control let a user choose from one or more items from the list. List boxes and drop-down list contain one or more list items. These lists could be loaded either by code or by the ListItem Collection Editor. Basic syntax for list box control: <asp:ListBox ID="ListBox1"        runat="server"        AutoPostBack="True"        OnSelectedIndexChanged="ListBox1_SelectedIndexChanged"> </asp:ListBox> Basic syntax for a drop-down list control: <asp:DropDownList ID="DropDownList1"       runat="server"       AutoPostBack="True"       OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged"> </asp:DropDownList>
Post a Comment
Read more