I would like to know how i can add text to my field result when i'm runing an SQL.
when ID = '1' then ('TEST_' + ID)
when ID = '2' then ('NO_TEST_' + ID)
end from location;
So if my ID = 1 then i want to add the text "TEST_" just before the value 1.
How can i do this?