Can Symmetric keys be used in a view?

Question

Is there anyway to use a summetric key from within a view definition?

I know how to use in a stored procedure, you basically need to issue the open key command:

OPEN SYMMETRIC KEY MyKey 
	DECRYPTION BY CERTIFICATE MyCertificate

But how to replicate this within a view...

Regards
Dave

Answer 1

Sorry, this is completely in the wrong forum.  More speed less haste :-)