How sql query accept an apostrof value?

[assimang]

Hello everybody,
I have a table in my sql data base, and the field type CharValue is nchar(1) which means that accepts characters.
In a record the value of CharValue is the character "'"
And that gets me in trouble when I try to execute the query

sql = "Select * from KbrdCharacters where CharValue='''"

What can I do to accept it?

Thanks anyone
in advanced.

 

[assimang]

solved. I set 2 apostrofs and its ok

sql = "Select * from KbrdCharacters where CharValue=''''