User Input

[darrylm]

Hi,

This is probably a simple question. Is it possible to get user input when running a query and then pass this to the query as part of a where statement?

ie
start query

User_input : xxx

where field_name = 'User_input'


As we want to pass this to other staff who have even less knowledge than me to run!

Darrylm

 

[MalcolmW]

The method for doing this tends to be database specific, so a generic solution is not that useful. So, perhaps a better question is "how do I do this in _________", posted in the _______ forum.
This is one area that ANSI SQL standards don't seem to work too well. Malcolm
Remember, if it wasn't for electricity, we'd be surfing the net by candlelight.