Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thambi1981
Starting Member
1 Post |
 Posted - 2010-04-29 : 10:57:18
|
| Hi,A column in a table has got Ecrypted data. That column is varchar(2000 ) . When I try to query the the column value, it's not showing the result in grid . But after pressing CNTR + T ( result to text), now i can see the data. How to populate the data in GRID itself?. Since I am trying to use the same table in informatica, informatica is also not picking the data. If i have any option in MS SQl server to make those data visible, that would be fine.. otherwise any conversion function or session orient statment ?... Regards,Thambi |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-04-29 : 12:04:43
|
| R u using SQL Server 2000 ?I am here to learn from Masters and help new bees in learning. |
 |
|
|
CrazyT
Yak Posting Veteran
73 Posts |
Posted - 2010-04-29 : 12:23:06
|
| it might be the encrypted data is base64 and you need to convert it to a string to see it |
|
|
|
|
|
|
Encrypted Data