ok this one is killing me 
STATEMENT
select * from customers where Sept > '6,000';
FIELD
Varchar
ok this is returning the number 6,7,8,... along with 60,70,80 .... 600,700,800..... 6000,7000,8000....
I only want to return those thaat are greater then 6,000 . I believe the comma has something to do with this.
Any thought would be greatly appreciated.
STATEMENT
select * from customers where Sept > '6,000';
FIELD
Varchar
ok this is returning the number 6,7,8,... along with 60,70,80 .... 600,700,800..... 6000,7000,8000....
I only want to return those thaat are greater then 6,000 . I believe the comma has something to do with this.
Any thought would be greatly appreciated.