how to use apostraphe in select statement

[ranga shreya]

Hi There,
I am trying to login as different names(newport news,Kohl's,macy's).
With my query I am abel to get my data for "newport news" not for"macy's".
My Question is how to get data if I login as "macy's". What could be the select statement.
Give me some suggessions.

[Annie Smith]

I suppose you need to escape that ' character. Use \\' to pass it in your query.

[David O'Meara]

Or you can use a PreparedStatement and these problems just... go away

[Jeanne Boyarsky]

Ranga,
Welcome to JavaRanch!

I agree with David that you should use Prepared Statements. The Sun tutorial walks you through the details.