Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    9

    Question Unanswered: Override SQL character

    I'm trying to search for all records that contain a quotation character in the database. These records were migrated from a mainframe system.

    I use the following command:
    %'%

    The results are:
    Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

    [Microsoft][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark before the character string ' order by cliLastName, cliFirstName, cliBirthName'.

    /ladds/lib/getrecordset.asp, line 6


    Is there a way to override the quotation character temporarily?

    Thanks ...

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    You just have to escape the character. Use this:

    Code:
     like '%''%'
    That is, two single quotes, and not a double quote.

  3. #3
    Join Date
    Feb 2004
    Posts
    9

    Thumbs up

    Thanks ... worked like a charm!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •