Member Avatar for carobee

How to encrypt and decrypt an existing column ?

  • 2 Contributors
  • 5 Replies
  • 81 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by carobee
Member Avatar for carobee

i want encryption of column in Sql.i have tried using symmetric key,but is there something simple.With HashBytes () we can encrypt but not decrypt

Edited by carobee because: n/a
Member Avatar for pritaeas

insert into table (mycolumn) values (encode('myvalue', 'mykey'))
select decode(mycolumn, 'mykey') from table

Member Avatar for carobee

i had solved it using PwdEncrypt() and PwdCmpare()

Member Avatar for carobee

Thanks anyway....

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.