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

[Moreno Andreo]

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.-