PDA

View Full Version : mySQL: Greater than 300 on varchar field


CricketWeb
Sat 19th Aug '06, 12:54am
I have a database field that contains numbers, and also a few letters, so I was forced into making it a varchar type.

What I'm trying to do is the following

select * from table
where Result >= 300

But the problem is, it doesn't seem to be work, which is obviously because of it being a varchar field. How can I get around it?