Hi,
I have an requirement in which i need to retrieve the data from ODS.
The query is like that:
EXEC SQL.
Select custdevice
into :tem_custdevice
where intersiteid = lotid.
ENDEXEC.
here the value of interside id will be for eg:ABC12345
and the value of lotid for eg: 12345.
So i need to ignore the ' ABC' and compare the remaining values of intersiteid and lotid.If it is matching retrive the record.
How can i do it?
Regrads,
Arun