Dear Experts,
i want to excute a query which have a condition that needs some casting. the table is MSEG the users are entering the reffrencing article document in the item text field. now all i need is to excute a query which have the mseg aliased and the joining condition should be mblnr with sgtxt
i imagine it should be something like this
select * from recmseg,supmseg where supmseg.mblnr=cast(recmseg.sgtxt as blnr)
recmseg is alias mseg for the recieving site
supmseg is alias Mseg for suplying site
so please can you tell me where i can write it and how to excute it and correct the syntax also