Hi,

I am trying to convert binary field in table tfgld106 -> dbcr ie. enumerated ib baan tables but in sql server it is binary field. When I use vscript , I unable to read the value . Can any one advise how to convert the value , that is readable in vbscript using sql. Thanks for help .


regards,

George

You can user CAST(dbcr AS INTEGER) in your SQL statement. That will produce the integer representation of the binary data.

Vince

select case t_dbcr when 1 then 'Dr' when 2 then 'Cr' else 'NA' end as drcr from ttfgld106200

You can use this one.

Regards
Rita