SELECT SINGLE mc_name1
mc_name2
FROM but000 INTO l_but000
WHERE partner = 'xxxxxxxx'.
TRANSLATE l_but000-mc_name2+1(34) to LOWER CASE.
TRANSLATE l_but000-mc_name1+1(34) to LOWER CASE.
CONCATENATE l_but000-mc_name2 l_but000-mc_name1 INTO lv_bpname SEPARATED BY space.
mc_name2
FROM but000 INTO l_but000
WHERE partner = 'xxxxxxxx'.
TRANSLATE l_but000-mc_name2+1(34) to LOWER CASE.
TRANSLATE l_but000-mc_name1+1(34) to LOWER CASE.
CONCATENATE l_but000-mc_name2 l_but000-mc_name1 INTO lv_bpname SEPARATED BY space.
No comments:
Post a Comment