Skip to Content
0
Former Member
Feb 02, 2009 at 11:48 AM

sub string in select

1982 Views

guys i want to fire this query by " AND b~material(4) = 'GH82'." gives error.Syntax not accepted

It gives error " b~material(4)" unknown.

Please do guide

SELECT acompany acustomer abill_no airis_repai

asvc_prod aserial_no acrt_serial aserialtype

arepair_rcv arcv_dt acomp_dt adlvry_dt

b~material

INTO CORRESPONDING FIELDS OF TABLE itab

FROM zest0 AS a INNER JOIN zest1 AS b

ON acustomer = bcustomer and

acompany = bcompany

WHERE a~company = 'C750'

AND a~svc_prod = 'HHP01'

AND a~iris_repai = 'A04'

AND b~material(4) = 'GH82'.