PRD Parameters

[den1832]

I am new to this and not the sharpest knife when it comes to sql, I have used Infomaker but PRD is a bit differnt in it's format.
I am trying to create a report straight from a spreadsheet that also contains images, so far so good all works fine, BUT, I need to add a parameter so that one column can be searched for keywords. I have added that paramter and then gone on to add the query in the data source, I have added this statement;
SELECT * FROM query_name WHERE column_name LIKE CONCAT(${parameter_name} , '%'). This is where it falls over, I can't link the 2 bits together.
I anybody is able to help it would be much appreciated, but please keep it simple.
Thanks

[Deanicus]

Your parameter syntax in the query looks fine, I just did a test one and it worked for me

The only thing I can think of is the data type of the parameter. Is it set to String?

[Lukfi]

query_name is the name of a table in the database?

[den1832]

Sorry, only just seen this reply, yes it is set to 'string' but the query will just not talk to the parameter