select statement

[Former Member]

Hi

i have created one RFC. in that one import parameter is clientname. after giving the clientname i want to check the database table wheather that word contains in the database table of that field. how to write select satatement with contains.

please help me

[Former Member]

hi,

select single * from table name where sy-mandt = xxxxx.

if sy-subrc = 0.

message i000(0) with 'User exists'.

else.

message i000(0) with 'User doesnot exists'.

endif.

Hope this is clear.

Thanks and regards

[Former Member]

Hi,

Write:

select f1 from tab1

where f1 like '%WORD%.

[Former Member]

Hi vishal

its not working.

[Former Member]

hi,

select single * from table name where sy-mandt = xxxxx.

if sy-subrc = 0.

message i000(0) with 'User exists'.

else.

message i000(0) with 'User doesnot exists'.

endif.

Hope this is clear.

Thanks and regards

[former_member195383]

suppose ztab is the database table....and wf_name is the parameter that u r passing.

select single namefield

into wf_namecheck from ztab

where namefield cs wf_name.

if sy-subrc = 0.

it is success..

Reward if useful...

[Former Member]

Try this:

concatenate '%' import_parameter_name '%' into v_clientname.

select single f1 from table1 where f1 like v_clientname.

if sy-subrc = 0.

• found

else.

• not found

endif.