Skip to main content
J
johnalo4-Participant
4-Participant
July 31, 2014
Question

SQL Statement Using like [[parameter]]

  • July 31, 2014
  • 1 reply
  • 2348 views

I am trying to pass an input parameter to a SQL statement using the like command. I cannot figure out how to write the statement using like.

Example

Select * from xxx where column like '%abc%' is what works.

If I pass an input value, how do I structure the statement:

Select * from xxx where column like '%[[parameter]]%' does not work.

Thanks

1 reply

A
adamtrainer5-Regular Member
5-Regular Member
August 5, 2014

Hi John,

My guess is Sabarish already spoke with you, but to concatenate two wildcards to the beginning and end of your input, you can use the '||' operator. For example,


SELECT * from xx WHERE column LIKE '%' || [[input]] || '%'


Thanks,

Adam



    Terms & ConditionsAccessibility statement