Sending a SQL statement with parameters

[Keith Hutchison]

G'day

Someone has asked me how to send in a SQL statement using parameters...
I don't normally do that :-( I normally create a query object, pass in
some parameters, let the query object sort it the correct SQL syntax
and execute the SQL.

Any examples of how to compose a straight SQL statement that won't
work unless the engine recognises the parameters ?

Thanks in advance.

-- 
Keith Hutchison
http://balance-infosystems.com