Okay so basically i want a prompt to appear when the query is run
for example:
Code:
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?