[RESOLVED] How can I use a special character in SQL?

If data in my database that create with MS-ACCESS contain a special character that use in SQL ( ', ", *, %, ?, _ ). How can I use SQL command to for this case?

For example my data in string type is

Don't
"Say"
*#06#
50%
What?
Student_Id


It's sure that i can't to use " select * from Table1 where Field1 like '*#06#' " for select the record of *#06#. So please help me.
It will be so clear if you can give me some example too.

PS. I found that double of ' (use single quote twice that not double quote ) in SQL statement as ' value data like this.
" select * from Table1 where Field1 like 'Don''t' "

Replace single ‘ with double ’ – as u found out
I don’t think any other characters cause any problems

I was wrong about the other characters they can’t be used.
The method to use them is to use it inside [ ]

For example

VB Code:

select * from Table1 where Field1 like 'j[*]anaka'

looks for j*anaka

To find out except ] all others can be found in this method.
To find out [ use it as normally

VB Code:

select * from Table1 where Field1 like 'j[[]anaka'

looks for j[anaka

VB Code:

select * from Table1 where Field1 like 'j]anaka'

looks for j]anaka

to find out more search in Access help using the word "Wildcard Characters"

Thank you