Extracting Text From varbinary(max) field

  • does anyone think it Possible to Extracting Text From varbinary(max) field in sql statement

  • Absolutely... 😉

    --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)

  • Notice, the answer above was almost as short and useful as the question... if you want a real answer, could you provide just a wee bit more info about what it is you'd like to do? Maybe show use some of the data in the original VARCHAR(MAX) and what it is you'd like to extract? :w00t:

    --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)

  • Hi Jeff,

    I am in search of a similar solution for my FTS project. Can you please have a look at my query on "Freetext query to get surrounding portion of text"?

    geo123abram

  • geo123abram (7/19/2011)


    Hi Jeff,

    I am in search of a similar solution for my FTS project. Can you please have a look at my query on "Freetext query to get surrounding portion of text"?

    geo123abram

    I responded although I'm not much help on the subject of FTS.

    --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)

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

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