Update binary column

  • The last two columns in one table is [StarText](varchar(20)) and [Star] (binary). It stored data like below:

    StarTest---Star

    ***

    **

    Null

    *****

    How to write a update code to insert star image at column [Star]?

    For example, at column [Star]

    row1 insert 3 stars

    row2 insert 2 stars

    row3 keep null

    row4 insert 5 stars

  • Have you considered looking at the code that did the insert?



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • Never mind. I did it in application.

Viewing 3 posts - 1 through 2 (of 2 total)

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