DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: problem in query when comparing strings

  1. #1
    Join Date
    Aug 2004
    Posts
    43,023

    problem in query when comparing strings

    [Originally posted by bvsmohan]

    hai

    i m getting problem when comparing string fields with another string which contains quote[']
    like "select * from table where field='value's'

    please help me
    thank u

  2. #2
    Join Date
    Aug 2004
    Posts
    43,023

    Re:problem in query when comparing strings

    [Originally posted by m.posseth@work]


    this should work

    "select * from table where field=""value's"""

    happy coding :-)

    p.s.

    if you want to enlarge this statementy use the & symbool an a space

    like this
    "select * from table where field=""value's""" & " order by bla bla "

    oh and something else it would be nice to close your sql with ;

    so a better ANSI SQL statement would be

    "select * from table where field=""value's""" & ";"




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center