Professional Web Applications Themes

Text Datatype - Microsoft SQL / MS SQL Server

Have you looked at PATINDEX in books online? "UR ednec" <com> wrote in message news:phx.gbl...  know  the ...

  1. #1

    Default Re: Text Datatype

    Have you looked at PATINDEX in books online?



    "UR ednec" <com> wrote in message
    news:phx.gbl... 
    know 
    the 


    Aaron Guest

  2. #2

    Default Re: Text Datatype

    Disclaimer: Low level of SQL Server knowledge - - - - -

    SELECT CHARINDEX('The text you''re looking for', TheColumn)

    Are you saying that that is not working for you?

    Ray at work

    "UR ednec" <com> wrote in message
    news:phx.gbl... 
    know 
    the 


    Ray Guest

  3. #3

    Default Re: Text Datatype

    > SELECT CHARINDEX('The text you''re looking for', TheColumn) 

    CHARINDEX won't work on a TEXT/NTEXT column if the pattern occurs beyond the
    8000th character.

    A



    Aaron Guest

  4. #4

    Default Re: Text Datatype

    You can use the PATINDEX command like this:
    DECLARE pos INT
    SELECT pos = PATINDEX ('%yourPattern%', theColumn) FROM yourTable
    WHERE yourCondition
    SELECT pos
    --
    HTH,
    SriSamp
    Please reply to the whole group only!
    http://www32.brinkster.com/srisamp

    "UR ednec" <com> wrote in message
    news:phx.gbl... 
    know 
    the 


    SriSamp Guest

  5. #5

    Default Re: Text Datatype

    Thank You

    "UR ednec" <com> wrote in message
    news:phx.gbl... 
    know 
    the 


    UR Guest

Similar Threads

  1. Replies: 4
    Last Post: September 22nd, 03:46 PM
  2. jtds sqlServer driver text datatype issue
    By lnagy in forum Coldfusion Database Access
    Replies: 1
    Last Post: April 7th, 05:54 PM
  3. Bit datatype
    By quixote in forum Microsoft SQL / MS SQL Server
    Replies: 3
    Last Post: July 21st, 06:27 PM
  4. Problems with Datatype TEXT
    By Petillin in forum Informix
    Replies: 0
    Last Post: July 8th, 08:45 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