Could someone please explain how I can use CL to get a variable into a Query. So that I can use the query parameter LIKE and have the ability to use the %.
Basically what I'm trying to do is create a screen, on that screen the user will enter a number for example 9000, I want the query that runs behind it to return results of 9000% to the screen, but I just can't get it to work. It's got to be really simple hasn't it?
This is all I want
Select A B C D from lib/file where A is like "Variable" order by A B C D
But I don't know how to pass a variable into a query. I tried SQL but when I built the query in that it came back with '9000%' so didn't like it.
Please note this is numeric data they are inputting and not alpha whcih may cause further problems.
Could someone please help it's driving me mad!