SQL user input

[gazneale]

Okay so basically i want a prompt to appear when the query is run
for example:

SELECT column FROM table WHEN anothercolumn=[insert column name here]

That query works in access fine as access recognises anything in [] as a prompt. However i'm using openoffice base and it doesnt recognise it.

Is there a standard SQL tag for a user prompt?

[D'Scouser]

It is a little confusing what you are trying to do, because on the face of it, it looks like you're trying to select a column with an escaped constraint.
I suppose it all depends what software you are using to return your data. You could try using one of MS's other escaped characters, such as ' or ".

[NickReffitt]

Try using WHERE as opposed to WHEN.