& in the where clause

From: JIM.H. (JIMH_at_discussions.microsoft.com)
Date: 10/22/04

  • Next message: Vishal Parkar: "Re: & in the where clause" 
    Date: Fri, 22 Oct 2004 05:09:06 -0700

    Hello,

    SELECT discounts.*, discounttype AS Expr1
    FROM discounts
    WHERE (discounttype = 'Initial & Customer')

    This query in pub database does not bring anything because of ‘&’ in where
    clause. How can I get this working without removing & in the table?
    Thanks,
    Jim.

  • Next message: Vishal Parkar: "Re: & in the where clause"

    Relevant Pages

    • Re: cannot write to database query
      ... The select query is as shown below, I cannot change the information in the ... What are the SQL views of significant queries? ... What I failed to mention is that this database was fully functioning last ... It has a TRANSFORM clause. ...
      (microsoft.public.access.queries)
    • Re: what makes this query not updatable
      ... Then compact the database. ... It has a GROUP BY clause (totals query). ... It has a TRANSFORM clause. ... > why the more complex queries with employee details and contracts tables ...
      (microsoft.public.access.queries)
    • Re: Using a Select Query to build a MDB table from a Fox table
      ... MS Access has a 'make-table' query with IN clause you can specify ... As you said the IN <database> clause is specific to Access SQL. ...
      (microsoft.public.fox.helpwanted)
    • Re: cannot write to database query
      ... What I failed to mention is that this database was fully functioning last ... we would need to know more about your table structure and query. ... Access MVP Allen Browne has summarized the reasons: ... It has a TRANSFORM clause. ...
      (microsoft.public.access.queries)
    • Re: Questions on format of Select statement
      ... Access Help on the FROM clause, ... This argument can be a single table name, a saved query, or a compound ... type The name of the database type used to create table if a database is not a ... You can also use the DATABASE reserved word to specify the external database. ...
      (microsoft.public.access.queries)