Error while Fetching data from BUT0ID data its urgent

[Former Member]

hi all,

SElECT SINGLE partner FROM but0id INTO l_bp

WHERE type EQ 'BUP008' AND

idnumber EQ edid4-sdata+45(10).

this is my select statement its not working i have to fetch partner number with the help of sdata.

when i give 69093 instead of edid4-sdata+45(10) then i am getting the output

when i specify edid4-sdata+45(10) then it is not working

please tell me any one its urgent

Thanks & regards

Vardhan

[Former Member]

hi all,

SElECT SINGLE partner FROM but0id INTO l_bp

WHERE type EQ 'BUP008' AND

idnumber EQ edid4-sdata+45(10).

this is my select statement its not working i have to fetch partner number with the help of sdata.

when i give 69093 instead of edid4-sdata+45(10) then i am getting the output

when i specify edid4-sdata+45(10) then it is not working

please tell me any one its urgent

Thanks & regards

Vardhan

[Former Member]

Hi,

Move this edid4-sdata+45(10) to a range or a field and then select your data.

If the hint is usefulu2026 Say thanks by rewardu2026.

Regards,

Prabhu Rajesh

[Former Member]

Even I Tried by the way you people said . Its not working any other solutions please

[Former Member]

Hi,

Try doing this.Take the offset of sdata and move it into a varaiable and then check the condition in the query.

Regards,

Sharath