SQL Syntax

[Steve95]

Hi All

Iam new to sql, Iam using sql 2000....I have a view which is returning 5 million records. I want to limit this down, I have 2 fields I want to limit this down by date and database type.

The date field is datatype: varchar
and the database type is datatype: varchar

The problem starts when I restrict the date and database type together. I only want to see certain dates and the database type within that daterange but my syntax returning all records that match the database type criteria.

select *
from vw_global
WHERE date >= '2006-09-30%' and
datebase_type like '%sale%' or datebase_type like
'%employee%'
or datebase_type like '%target%'

I hope I have made sense.

I look forward to your response.

 

[Otto]

select *
from vw_global
WHERE date >= '2006-09-30%' and
(datebase_type like '%sale%' or datebase_type like
'%employee%'
or datebase_type like '%target%')

and you, perhaps, should revise the date >= '2006-09-30%' expression...

 

[bborissov]

Yes it will returns that because you didn't put any brackets around IFs"

And because I doubt you have database_type like this 'someone sale somethig' I removed ALL LIKE clauses

select *
from vw_global
WHERE date >= '2006-09-30' and
    datebase_type IN ('sale', 'employee', 'target')

but just on case I am wrong or you insist to use your first query:

select *
from vw_global
WHERE date >= '2006-09-30%' and
      (datebase_type like '%sale%'     or
       datebase_type like '%employee%' or
       datebase_type like '%target%')

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP