Hello all!
When I run this Query as an Import:
SELECT ID, OWNER, EMAIL
FROM dbo.CLEAR_AUX
i get...
<Binary data> as ID
Barry Bonds as OWNER
abbonds@gmail.com as EMAIL
I need it to Read...
0x004700DD24EBF06E46E0A707561C0BE83EC0 as ID
Barry Bonds as Owner
abbonds@gmail.com as EMAIL
For some reason when i right click the table and select either SELECT TOP or EDIT TOP i get the right values...
But when i GOTO Views and add the table with checkmarks for ID, Owner, and EMAIL its changing the ID to Binary...same with doing an import from that table what am i doing wrong?
Can you elaborate further on this please? We need to know where the data is coming from, what you are using for the import, the destination definition and any other details that are relevant.
😎