|
View previous topic :: View next topic
|
| Author |
Message |
garv_fundu
Warnings : 1
New User
.jpg)
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 |
|
|
|
|
