I'd like to mention here that typically when encrypting like this you store the data one place, the keys in another.
In general I'd have the N-Tier control the encrypt/decrypt, and the SQL Server store it. This way under normal breaks they can only get half of the pieces they need for the problem.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA