select query offset.

[Former Member]

hi ,

Is this select query Possible.

SELECT COUNT(*) FROM t179

WHERE prodh+8(3) IN so_fam

AND stufe = 4.

This query is showing error, how to validate the select query.

Regards,

Madhavi

[Former Member]

Hi Madhavi,

SELECT COUNT(*) FROM t179

WHERE prodh+8(3) IN so_fam

AND stufe = 4.

This is not a valid select query.

U proceed like,

Data: V_prodh like proth.

V_prodh = prodh+8(3).

SELECT COUNT(*) FROM t179

WHERE V_prodh IN so_fam

AND stufe = 4.

Reward if helpful.

[Former Member]

Hi,

Correct the code accordingly.

SELECT COUNT(*) into i_count FROM t179

WHERE where stufe = 4 and substr(prodh,8,12) in s_fam.

If it is helpfull pls reward pts.

Regards

Srimanta

[Former Member]

hi Srimathe,

This particular piece of code is not working in my system.

Will you please check once and send it to me.

Will you please send the standard SAP help for SUBSTR .

Madhavi

Edited by: varisetty madhavi on Apr 29, 2008 5:34 PM

[Former Member]

thanks