How do I mask a Varbinary image column?

  • 0
  • 1
  • Question
  • Updated 3 weeks ago
Hi Hims,

I want to mask an Varbinary(max) image column with a single image for a selected rows and another image for other selection of rows in a same column. How can I achieve this using Binary Lookup Algo?

Note: This conversation was created from a reply on: Functioning of Binary Lookup Algorithm.
Photo of Rajesh Dadi

Rajesh Dadi

  • 402 Points 250 badge 2x thumb

Posted 3 weeks ago

  • 0
  • 1
Photo of Mayank Ahluwalia

Mayank Ahluwalia

  • 646 Points 500 badge 2x thumb
Hi Rajesh,

You can create 2 binary lookup algorithms for the 2 different images. You can then apply them to the same column by creating 2 rulesets for the same table.

The rulesets can have the rows filtered by either filter criteria or custom SQL based on your selection criteria


Regards,
Mayank
Photo of Rajesh Dadi

Rajesh Dadi

  • 402 Points 250 badge 2x thumb
Thanks a lot, this will be helpful