WHERE Statement Help

Discussion in 'ASP General' started by Simon Gare, Jun 18, 2006.

  1. Simon Gare

    Simon Gare Guest

    Hi,

    cant get to grips with this problem, need to select from dbo.booking_form
    all records that meet 2 statements. 1st allocated='completed' and 2nd
    account is not 'CASH' , i.e. all records that don't contain the word CASH in
    the field 'ACCOUNT' Below is the beginning just don't know the syntax for
    NOT, have tried several option but to no avail.

    Pricing.Source = "SELECT * FROM dbo.booking_form WHERE allocated =
    'COMPLETED' AND

    Thanks in advance.

    Simon
     
    Simon Gare, Jun 18, 2006
    #1
    1. Advertising

  2. Simon Gare

    Mike Brind Guest

    Simon Gare wrote:
    > Hi,
    >
    > cant get to grips with this problem, need to select from dbo.booking_form
    > all records that meet 2 statements. 1st allocated='completed' and 2nd
    > account is not 'CASH' , i.e. all records that don't contain the word CASH in
    > the field 'ACCOUNT' Below is the beginning just don't know the syntax for
    > NOT, have tried several option but to no avail.
    >
    > Pricing.Source = "SELECT * FROM dbo.booking_form WHERE allocated =
    > 'COMPLETED' AND
    >
    > Thanks in advance.
    >
    > Simon


    Pricing.Source = "SELECT * FROM dbo.booking_form WHERE allocated =
    'COMPLETED' AND accounts <> 'CASH'

    --
    Mike Brind
     
    Mike Brind, Jun 18, 2006
    #2
    1. Advertising

  3. Simon Gare

    Simon Gare Guest

    Thanks Mike

    "Mike Brind" <> wrote in message
    news:...
    >
    > Simon Gare wrote:
    > > Hi,
    > >
    > > cant get to grips with this problem, need to select from

    dbo.booking_form
    > > all records that meet 2 statements. 1st allocated='completed' and 2nd
    > > account is not 'CASH' , i.e. all records that don't contain the word

    CASH in
    > > the field 'ACCOUNT' Below is the beginning just don't know the syntax

    for
    > > NOT, have tried several option but to no avail.
    > >
    > > Pricing.Source = "SELECT * FROM dbo.booking_form WHERE allocated =
    > > 'COMPLETED' AND
    > >
    > > Thanks in advance.
    > >
    > > Simon

    >
    > Pricing.Source = "SELECT * FROM dbo.booking_form WHERE allocated =
    > 'COMPLETED' AND accounts <> 'CASH'
    >
    > --
    > Mike Brind
    >
     
    Simon Gare, Jun 18, 2006
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    3
    Views:
    833
  2. Jay McGavren
    Replies:
    11
    Views:
    1,181
    Alan Krueger
    Jan 16, 2006
  3. tedsuzman
    Replies:
    2
    Views:
    7,164
    Michel Claveau, résurectionné d'outre-bombe inform
    Jul 21, 2004
  4. Ted
    Replies:
    1
    Views:
    494
    Duncan Booth
    Jul 22, 2004
  5. Replies:
    21
    Views:
    1,086
    Giannis Papadopoulos
    Aug 2, 2005
Loading...

Share This Page