Hi Grant,

Thanks for the reply. My table is not a heap and we created a index on rosterdate, usercode and rosterdate, usercode & Shiftcode.

Most of the reports based on these...

• This reply was modified 4 years, 5 months ago by  Grant Fritchey. Reason: Fixed some typos

Hi,

Have checked that link, the system suggests creating one more new field with datatype varbinary or varchar then encrypted data to store that field.

My database is running client environment and...

Hi Phil

Thanks for your quick reply.

I google this question and found some threads but can't match my requirement. That's why I posted here.

Will you please help me out.

Thanking you