Rmove duplicate contents

[gatetec]

A table (IntakeCom) has duplicate contents as below.

clientno reason
564 Lack of Support, Emotional Problems
564 Lack of Support, Lack of Support
564 Lack of Support, Physical Impairment
564 Lack of Support, Poor Living Condition
564 Lack of Support, Poor Personal Hygien
.....

How do you remove those duplicate contents so that it shows as below?

564 Lack of Support, Emotional Problems, Physical Impairment, Poor Living Condition, Poor Personal Hygien

thx so much

 

[PHV]

Have a look here:
faq701-4233

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[gatetec]

I ran it, and now I see the dup contents in each record.
Obviously, it removed dup rows, but the dup contents are there.

clientno reason
415 Lack of Support, Lack of Support
416 Lack of Support, Lack of Support
418 Lack of Support, Lack of Support
420 Lack of Support, Lack of Support
421 Emotional Problems, Emotional Problems, Emotional Problems, Lack of Support
422 Emotional Problems, Emotional Problems, Emotional Problems, Lack of Support

Please advise.

 

[PHV]

Have a look at the DISTINCT predicate.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886