0

SQL Like operator

Rémi Bastien

December 21, 2016 09:15

None

Follow

Hi,

I need to use a SQL function with a Like operator. Do you know how to do that ?

Many thanks.

• Facebook
• Twitter
• LinkedIn

4 comments

• 
  Janice Janczyn December 21, 2016 13:15 Official comment

  Hi Rémi,

  w3schools.com is an excellent resource for technical information.  Their SQL material is at http://www.w3schools.com/sql/default.asp and their description of the LIKE syntax is at http://www.w3schools.com/sql/sql_like.asp.

  Hope this helps!

  Thanks,

          Janice

• 0
  
  Rémi Bastien December 22, 2016 10:09

  Hi Janice,

  Thank you for your answer. Actually, I know how to use this operator in a SQL function, but I didn't find it in Klipfolio.

  I solved my problem with CONTAINS().

• 0
  
  Janice Janczyn December 22, 2016 13:23

  Hi Rémi, my apologies, I misunderstood your question. Glad to hear you found the CONTAINS function. If you want a case-insensitive comparison, wrap the LOWER function around each parameter to convert them to lower case:

     CONTAINS( LOWER (haystack), LOWER(needle) )

  Happy klip-building!

  Janice

• 0
  
  Matt Gabrielson April 11, 2022 12:58

  Thanks for added the LOWER function reference. Saved me a ton of debugging.