Retreive data from table

[Former Member]

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

[sivasatyaprasad_yerra]

Use: where intersiteid like lotidtemp.

where lotidtemp will be % concatenated by lotid variable. So, in this case it will be %12345. % Stands for any number charcters.

Regards,

Siva.