TRIM function Removes leading or trailing characters (or both) from a character string.
Syntax: TRIM([ { { LEADING | TRAILING | BOTH } [ trim_character ]| trim_character}FROM ]trim_source)
TRIM(‘,’ FROM {fieldID}) will remove the ” , ” from the field values.