Re: CASE(?) to write in a different column based on a string pattern

[Moreno Andreo <moreno.andreo@xxxxxxxxxx>]

Il 13/11/19 17:36, Geoff Winkless ha scritto:
> Simplest way in plain SQL would be individual case statements for each
> column, I think.
>
> SELECT pattern,
>    CASE WHEN pattern LIKE 'foo%' THEN SUBSTR(pattern, 4) ELSE '' END AS foo
>    CASE WHEN pattern LIKE 'bar%' THEN SUBSTR(pattern, 4) ELSE '' END AS bar
>    CASE WHEN pattern LIKE 'baz%' THEN SUBSTR(pattern, 4) ELSE '' END AS baz
> FROM tbl;
>
> Geoff
Geoff,
    it worked perfectly!

Thanks a lot!
Moreno.-