Post reply

PatIndex on varbinary Column

  • June 17, 2008 at 1:13 am

    #188013

    Hi,

    I have a Table which holds varbinary column(word document). I need to search few keywords in this column.

    How to use PatIndex on varbinary column?

    Thanks,

    Uma Ramiya

  • June 17, 2008 at 11:12 pm

    #830200

    Open a Word document in a text editor like Notepad and let me know if you think a search for any word would actually work...;)

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • June 18, 2008 at 3:00 am

    #830265

    I found a solution through another form member. for those who have the same issue please go thru the following link

    http://msdn.microsoft.com/en-us/library/ms187787.aspx

  • June 18, 2008 at 7:24 am

    #830398

    Thanks for sharing...

    But that's still going to have the same problem as PatIndex... For example... if you're looking for the word "GUID" or the word "DEFAULT" in a word document, you'll find that ALL word documents contain those words.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • June 18, 2008 at 8:16 am

    #830473

    Try something like this (adapted to your environment):

    Declare @S varchar(256),@v varbinary(256)

    Select

    @S='String with wierdness'+Char(127)+' in it...',

    @v=cast(@s as varbinary)

    Print @S

    Print @v

    Print patindex('%'+Char(127)+'%',cast(@v as varchar))

    I've run into cases where the above PATINDEX may need to be augmented with a COLLATE predicate; I usually use collation "Latin1_General_BIN" in that case.


    PeteK
    I have CDO. It's like OCD but all the letters are in alphabetical order... as they should be.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply