Need help to exclude ' from query

[aph]

Hi all,

I want to exclude from our table all ' . For example we have stored in one of the column Int'l. We do not want all those rows in which ' exists. Can any one help me?

Thanks in advance

[Highlander]

Your "WHERE" in part should look like this:

WHERE COL_1 NOT LIKE '%''%'

[aph]

Thanks Highlander it works perfect.

I like your WS.

Thanks
aph