Filtering

[StateSQLboy]

I am doing a Select Count statement and I want to exclude everything in the column ending in an 'x' or an 'e'. With my limited knowledge of this stuff, I would appreciate any help.

 

[SQLBill]

So you got one F and one N returned? That's suprising. MAX(funding) should return ONLY the MAX value of that column and the letter N is the MAX of the two. So, your query should always return N. Unless once the WHERE eliminates some entries all the FUNDING entries are only F's.

Does this return only a single F?

Select MAX(Funded)
From Table1
Where RIGHT(LocationID,1) <>'X' and RIGHT(LocationID,1) <> 'E'

-SQLBill

 

[StateSQLboy]

Yes A single F