Concatenate information from 2 fields

Hi, how can I concatenate 2 fields into 1? For example I have field ID and field Name so I want to concatenate it to have “ID-Name”

Hi, in php use concat operator .

{ID}."-".{Name}

Or sc_concat() if is SQL

{newfield} = {ID}.{Name};