Question

What's difference LIKE and ILIKE ??

Forum|Forum|6 years ago
August 31, 2020
1 reply
2 views

Forum|alt.badge.img

+2

HyeontaeJu
Participating Frequently

My quesetion is same with the title
What's difference LIKE and ILIKE ??

Forum|alt.badge.img

+2

Jim_Knicely
Participating Frequently
Forum|Forum|6 years ago
August 31, 2020

ILIKE is case-insensitive.

Doc Page:

https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/LanguageElements/Predicates/LIKE-predicate.htm

Like