I was trying to check certain string with regex condition like wind 10 wind 9 ..so on win vis here is the case statement i tried but didn't found any luck
case
when REGEXP_LIKE(lower(hos_o),'.*(Wind.?(6\.1|7|8|10|11|.*(CE|Vis|P))
|^(?i)(ac|ac.?OE.?|OE X|maS)|Work).*') then 'ent'
while using this regex function to check getting an error