Hi,

I would like to write a script with some LIKE.
My script have to deal with a non defined number of arguments.

That means that I have to send :
SELECT ...
FROM ...
WHERE FIELD LIKE "TOTO%" OR FIELD LIKE "TITI%"

While TOTO and TITI can also be added with TUTU and others.

Who can I deal with a non defined number of parameters ?
Who can I create my request dynamically ?

In a Unix ksh, it would be something like :
while (( $# > 0 ))
echo "LIKE '$1%'"
shift
end

Olivier