concatenate fieldvalues with a slash inbetween

[chriys1337]

Hi,

I would like to concatenate some field values but add a slash '/'  in between.

Table:

LOAD

CONCAT(Field,'&', ID) as Fields1, // works fine, Result A&B&C

CONCAT(Field,'& chr(39) / & chr(39) &', ID) as Fields2  // does not work; it should be A&'/'&B&'/'&C

Resident FieldNames;

Can anybody please help me?

BR,

chriys

[marcus_sommer · Accepted solution]

The syntax is wrong. You may try it with:

CONCAT(Field,'&''/''&', ID) as Fields2