View previous topic :: View next topic
|
Author |
Message |
garv_fundu Warnings : 1 New User
Joined: 02 Nov 2006 Posts: 22
|
|
|
|
hi all,
i have a query like...
select * from Tbl where Name in ('hello','children's','world');
its not recognizing any character after 's in children's...
i think its taking ' as the string terminator...
kindly help me regarding this...
thanks in advance |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
Have you checked the manual to see how quotes can be handled within quotes? |
|
Back to top |
|
|
garv_fundu Warnings : 1 New User
Joined: 02 Nov 2006 Posts: 22
|
|
|
|
William Thompson wrote: |
Have you checked the manual to see how quotes can be handled within quotes? |
no... just post the solution here please.... |
|
Back to top |
|
|
DavidatK
Active Member
Joined: 22 Nov 2005 Posts: 700 Location: Troy, Michigan USA
|
|
|
|
Check HERE for an example from the manual |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
DavidatK wrote: |
Check HERE for an example from the manual |
Thanks Dave, like a well trained dog, I went searching but just couldn't find the example needed (limited, sloooow resources at home)....
Bill |
|
Back to top |
|
|
pravena
New User
Joined: 31 Jan 2007 Posts: 9 Location: chennai
|
|
|
|
Hi,
If you include another ' (single quotes) before s in childern''s i think u can get the required result
Pls correct me if i am wrong |
|
Back to top |
|
|
vini_srcna
Active User
Joined: 26 May 2005 Posts: 178 Location: Copenhagen, Denmark
|
|
|
|
select * from Tbl where Name in ('hello','children''s','world'); should work. |
|
Back to top |
|
|
|