Select Query!!!

Hi All,

Am using the following query to retrieve a record from a customized infotype table.

But the highlighted portion in the query is not allowed in the Select statement it seems.

Any suggestions, how can i retrieve the data based on the following conditions, and omitting all the records of subtypes starting with 'Z'????

Please help...!!!!

SELECT SINGLE zz_rc_no FROM pa9235 INTO gwa_9180_emp-zzrecall_id

WHERE begda <= gwa_claims-g_trg_start AND

endda >= gwa_claims-g_trg_end AND

<b>subty+0(1) <> 'Z' AND</b>

( zz_os = '01' OR zz_os = '43' OR zz_os = '53' ).

Thanks!!!

Regards,

Sundar.