-----------------------------------------------------------

New Message on BDOTNET

-----------------------------------------------------------
From: s_hashim
Message 4 in Discussion


replace single quote with two single 
quote
try like this query

select * from topic where topic_text like 
'%''%'
 
 

Keep Smiling, 
Regards. 

Sayad Hashim Ali Kazi
SQL Star International Ltd.
SQL 
House,
#13,Infocity,Madhapur,
Hyderabad 500033.
Tel: 
+91-40-23101625(Off)
     +91-40-55365573(Res)
e-mail: 
[EMAIL PROTECTED] 
website: www.sqlstarintl.com 

  -----Original Message-----
From: BDOTNET 
  [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 
  2:09 PM
To: BDOTNET
Subject: Like operator with quotation 
  mark


  
    
      
      New Message on BDOTNET
    
      

  Like 
    operator with quotation mark


    
      
      
        Reply

        
          
            
            
               
              Recommend 
              Message 1 in 
                Discussion 
      
        
          
            
            
              From: Dhanaventh 
            
              

                Hi ,
                 
                Pl help me with query which has a quotation mark. How do i 
                seach for quotation mark's using 'like' operator.
                 
                select * from topic where topic_text like '%'%'
                 
                Thanks
                 
                Dan
View other groups in this 
    category. 



-----------------------------------------------------------

To stop getting this e-mail, or change how often it arrives, go to your E-mail 
Settings.
http://groups.msn.com/BDOTNET/_emailsettings.msnw

Need help? If you've forgotten your password, please go to Passport Member Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help

For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact

If you do not want to receive future e-mail from this MSN group, or if you received 
this message by mistake, please click the "Remove" link below. On the pre-addressed 
e-mail message that opens, simply click "Send". Your e-mail address will be deleted 
from this group's mailing list.
mailto:[EMAIL PROTECTED]

Reply via email to