InfoPath Dev

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, "%", "'")

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?

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.