Professional Web Applications Themes

String Find Function - Microsoft SQL / MS SQL Server

Are there any functions in SQL Server to find the index of a char in a string i.e. declare index int set index = ????('This is my string', 's') Thanks Mike...

  1. #1

    Default String Find Function

    Are there any functions in SQL Server to find the index of a char in a
    string

    i.e.

    declare index int
    set index = ????('This is my string', 's')

    Thanks
    Mike


    Mike Davies Guest

  2. #2

    Default Re: String Find Function

    Check out CHARINDEX & PATINDEX functions in SQL Server Books Online.

    --
    - Anith
    ( Please reply to newsgroups only )


    Anith Sen Guest

  3. #3

    Default Re: String Find Function

    Mike,

    Use CHARINDEX as such:

    Set index = CHARINDEX ('s', 'This is my string')

    Use PATINDEX for limited wildcard searching.

    Russell Fields
    "Mike Davies" <mpdmindless.com> wrote in message
    news:eofZUJ9PDHA.304tk2msftngp13.phx.gbl...
    > Are there any functions in SQL Server to find the index of a char in a
    > string
    >
    > i.e.
    >
    > declare index int
    > set index = ????('This is my string', 's')
    >
    > Thanks
    > Mike
    >
    >

    Russell Fields Guest

  4. #4

    Default Re: String Find Function

    Try CHARINDEX.

    Regards,
    Raj

    "Mike Davies" <mpdmindless.com> wrote in message
    news:eofZUJ9PDHA.304tk2msftngp13.phx.gbl...
    > Are there any functions in SQL Server to find the index of a char in a
    > string
    >
    > i.e.
    >
    > declare index int
    > set index = ????('This is my string', 's')
    >
    > Thanks
    > Mike
    >
    >

    Khooseeraj Moloye Guest

Similar Threads

  1. Find and cut string
    By Ola Ekedahl in forum PHP Development
    Replies: 1
    Last Post: November 23rd, 01:48 PM
  2. P part of string (mid string function ?)
    By mimages in forum PHP Development
    Replies: 7
    Last Post: September 27th, 12:58 AM
  3. [PHP] find string
    By Carl Furst in forum PHP Development
    Replies: 3
    Last Post: August 11th, 12:19 AM
  4. find in string
    By Bite My Bubbles in forum ASP
    Replies: 4
    Last Post: August 9th, 08:02 PM
  5. find string in files
    By lallous in forum SCO
    Replies: 4
    Last Post: August 6th, 12:57 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139