Identify if comma is present in a field

Summary

How to do that in OTBI?

Content

Hi,

we need to embed the following logic into OTBI report

   (CASE 

      WHEN hr_loc.location_name like '%,%' then '"'||hr_loc.location_name||'"' 

      ELSE hr_loc.location_name 

END) g2_location_name,

 

Any ideas?

 

Thanks 

Nicola