Yes, the select you provided is working for TEST.
It seems that this error comes from unexpected data in the field like this:
Dave PARIS11,30,CANNES40,C22,TOULOUSE1
Amr PARIS11,30,CANNES40,C22,TOULOUSE1
Barb CAEN14,37,55,DIJON,21,D33,LIMOGES12
Tarek...