single quotes problem

I am building a sql query based on user input and the field value from the database contains single quotes e.g., Baccharis 'Centennial'

The application/query fails on this request because of the single quotes in the name.

How can i escape <whatever> the value in the java code to allow single quotes

Running Oracle 9i and java 1.4

Thanks

[376 byte] By [farmboy] at [2007-11-26 8:02:05]