|
-
Apr 22nd, 2002, 09:20 PM
#1
Thread Starter
Hyperactive Member
[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' "
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|