Query Sintax

What is the syntax for the query if I want to do the where clase like with the Retreival Argumet?


Where id like :Argument.
I need to pill all the ids that are Like : Argument
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

//assuming that argument value = sle_1.text

string ls_id
ls_id = '%'+sle_1.text+'%'

select * from table_name where id like :ls_id

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
You could code it directly in your dataobject by choosing the like operator in the where clause tab and then in the menu area choose design and select retrieval argument.


The dataobject syntax will look something like this:

SELECT schema.table.id  
FROM schema.table
WHERE schema.table.id like :argument  


Personally I like to use a more dynamic method but it goes beyond the scope of this question.  I do not use any arguments in my SQL and dynamically build the where clause on the fly.  In this way I have fewer objects and each object has much more flexibility and can be extended for other uses.  There is a performance consideration but in many cases is not an issue.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Editors IDEs

From novice to tech pro — start learning today.