Captain Paralytic <paul_lautman@yahoo.com> wrote:

> 3) The function "SUBSTRING(artista, LOCATE( ' ',artista))" will
> include the space in its result and so the LIKE 'W%' will fail,
> because it doesn't taek into account the leading space. Thus teh
> function "SUBSTRING(artista, LOCATE( ' ',artista))" should read
> "SUBSTRING(artista, LOCATE( ' ',artista)+1)"
>
> But apart from the fact that there were so many mistakes, it was
> perfectly correct!

fantastic!!
thanks a lot!
now all works fine!