Is there a way to encrpt data (ie. a credit card number or personal information) and then retrieve it from the database later using a SELECT Statement. I am trying to get away from:

Insert into saiddatabase values password(something);
select * from saiddatabase where creditcardnum = password(something);

Any suggestions?
Thank you.

Is SSL good enough?

-PatP

Sure, how would you do that?