Skip to Content
1
Oct 22, 2019 at 08:34 AM

SAP HANA SQL

123 Views

I Want to concat three fields,but The result of the method shown in the picture1 and picture2 is empty,Please Tell me how to correct it

Such as database table data:

fmsno service_o service_f service_m

fms01 0002 0015

fms02 0008

fms02 0003

the expect results:

fms01 service_type_zh1

fms01 a/c

fms02 b

fms03 a

Attachments

picture1.png (15.8 kB)
picture2.png (17.8 kB)