Skip to Content
0
Former Member
Jun 29, 2009 at 02:10 AM

Retreive data from table

38 Views

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