SQLTeam.com | Weblogs | Forums

Ilike vs like function..simple stuff , but a bit confused!


So I'm writing a simple case when statement where I'm renaming certain attributes:

when attribute_value ilike '%Sports Channel Value%' then 'Sports Channel Value'
when attribute_value ilike '%REF Sports Channel Value%' then 'REF Sports Channel Value'
else attribute_value end

And it's clustering the 2 renames into the same category when I recall them.

The reason why I'm renaming is each string will have .email day 1, .emailday3, .emailday5, etc etc so I want to roll up the naming to avoid having a messy output.


OK -- so what's your question? (BTW there's no ILIKE operator in SQL Server)


I think ILIKE is an Oracle construct which lets you do case-insensitive comparison.