Post reply

Check varbinary field

  • April 21, 2006 at 8:01 am

    #112770

    Is there a way in SQL Server to return whether a varbinary or binary field contains data or not - a kind of ISEMPTY function ?

  • April 21, 2006 at 8:32 am

    #633521

    Did you allow nulls then col IS NULL or are you looking to see if = like 0x0000000000000000, in that case you should be able to say where column = 0x00.

  • April 21, 2006 at 12:38 pm

    #633594

    Thanks Antares,

    Yes it was a field that doesn't allow nulls, I should have specified. the column = 0x00 works fine

    Cheers

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

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