Results 1 to 2 of 2

Thread: Alternative ' char in SQL? [Resolved]

  1. May 26th, 2004, 10:58 PM #1
    Hinder
    Hinder is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Dec 2002
    Posts
    382

    Alternative ' char in SQL? [Resolved]

    Is there an alternative to using the ' character in SQL? Since the ' character is used to parse the string objects in a Query, That kinda makes it tough to store Don't and Can't and other words of the type where you need the data to be stored grammatically correct?



    [Update]

    Thanks, works like a charm...
    Last edited by Hinder; May 26th, 2004 at 11:56 PM.
    Reply With Quote Reply With Quote
  2. May 26th, 2004, 11:37 PM #2
    mendhak
    mendhak is offline
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170
    Replace(strSQL, "'", "''')

    in your query string.

    '' comes down to '. (That's two single quotes, not a double quote)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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