Yes I thought so and I understand the decryption issue. With regards to encrypting in application do you mean that a similar methodology to that in SQL Server could be employed, or would "bespoke" code have to be written from scratch?

By that I mean, can the database encryption process be applied at the application level by some means?