Qdabra qRules

Re: Correct Syntax for "Contains" or "like"

douglasjenn — Wed, 02 Jan 2013 15:40:53 GMT

Working like a charm now. Thanks so much!

Re: Correct Syntax for "Contains" or "like"

Hilary Stoupa — Mon, 31 Dec 2012 19:48:06 GMT

Oh - good catch, I didn't even see those!

Re: Correct Syntax for "Contains" or "like"

Jimmy — Mon, 31 Dec 2012 19:46:24 GMT

Is there a reason for the pair of apostrophes after the first %? Those could be preventing any results from coming back.

And please make sure you are validating LastName (i.e. ensuring that it does not contain any apostrophes) before using it in an SQL query.

Re: Correct Syntax for "Contains" or "like"

Hilary Stoupa — Mon, 31 Dec 2012 15:54:14 GMT

Well, the syntax is where ColumnName like '%value%', so, in general, this looks correct. Can you open SQL Management Studio and try to execute your query with a where clause and the value you are trying for last name and see what your results are?

Correct Syntax for "Contains" or "like"

douglasjenn — Mon, 31 Dec 2012 14:23:18 GMT

I need to pull in results from a SQL table into an Infopath. I would like for it to only return values that "contain" a value. (For example, only pull where OED_Relationship contains employee last name) . What is the correct syntax when using the concat statement to return "like" results?

Here's my current code which is definitely not working.

concat("ModifySqlQuery /dsname=DailyEDWforOEDCustomers /where=where v_dv_RPCode_052.OED_Relationship like '%''", LastName, "%", "'")