Skip to Content
0
Former Member
Jan 24, 2011 at 05:56 PM

CreditCard numbers masked when performing a select query on BP with CC's

188 Views

Hello,

We just upgraded our 8.8 PL11 db to PL14. Now, when I run a SQL Query:

SELECT T0.CardCode, cast(T0.CrCardNum as varchar(100)) + '     ' + CAST(T0.CardValid AS VARCHAR(11)) +  '   ' + T1.PymntGroup
 FROM OCRD T0
INNER JOIN OCTG T1 ON T0.GroupNum = T1.GroupNum

the output shows the Credit Card Number as an encrypted/masked string. Is this an undocumented change? Or a bug? or am I missing a setting somewhere?

Thank You in advance!

Curt