WHERE Statement Help

[Simon Gare]

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

 

[Mike Brind]

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'

 

[Simon Gare]

Thanks Mike

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