How to specify special characters(alphabets) in WHERE clause

Database

How to specify special characters(alphabets) in WHERE clause

Hi,

I got one query where in i have to specify special characters in where clause.

Below is example.

column1 is varchar(10) and it  has multiple values like 'dettile','sÄetl','uyrtf'......

Now my requirement is to find the rows which has got column1 values like ('dettile','sÄetl').

I wrote query like below

sel * from table where column1 in ('dettile','sÄetl')...it is not working for 2nd value.

I have also tried with chr() function like below but it is giving syntx errors.

sel * from table where column1 in ('dettile','s'||chr(197)||'etl').

Can anybody please help me how to solve this.......

For time being i modifed the query with multiple OR clauses.....want to know how can we specify in WHERE clause.

Thanks,