How to dynamic SQL query

[Anonymous]

hi 

i  try a job by a dynamic query who return the code_grille who contain all condition 

exemple:

i have create a query who return the code_grille who contain all condition 

code_grille :1234 like '%1%' and like like'%2% etc 

now if there a false clause "where like"

i need choose the greatest code_grille who return the maximum of  condition "likes" (not all)

this is my job i the first part 

ideas please!

[akumar2301]

Not Very clear . 

Can you please explain with example ?

[fdenis]

I think You are looking for dynamic query.
do you know how to use global Map?
and tmap lookup for each row?
Regards