On May 5, 3:17 pm, "cvh@LE" <christian.han...@cpi-service.com> wrote:
> Hi all,
> ...
> Any hints or tips or reference I didnt find?

RTFM would reveal SUBSTRING_INDEX():
http://dev.mysql.com/doc/refman/5.0/...ubstring-index

> TIA
>
> Chris