SQL Giving a user the chance via a form, to alter a sql where clause,

[buttersoft]

Does anyone know how to present a user with a form, which asks them to complete their choices to search for, and then this input is entered into the WHERE clause of the script and the script runs.

I have a script that looks for 3 to 4 letter codes in a file with several thousand such codes. The user could decide he wants to report on ARM PON XAR for example, and thus the WHERE clause would have to be modified to
WHERE (EPIC = 'ARM OR EPIC = 'PON' OR EPIC = 'XAR), so what I want to do is present a form asking for a list perhaps seperated by a TAB or comma of EPICS, and then this has to overwrite the WHERE clause that is presently in the SQL script.

Anyone know how to do this?

 

[sonso]

Did you get an answer on this? You'll need to declare a string variable(s) and use a tilde (~) to address them. E-mail me at Noah_Osnos@TommyBOy.com.