Using Where-Clause in a query

Question

I'm having problems with a Where query. It doesn't seem to work or its not right

select * from FP where FP.Paid Amount => '100' 

I'm trying to only display the people who have paid over 100 in the DB

Any Ideas?

Thanks

Answer 1

Reverse the '=' and the '>'. Also, a @ of the leading '"' will prevent the compiler from trying to translate any of the string content.

string myQuery = @"select * from FP where FP.Paid Amount >= '100' ";

Answer 2

Did you mean to do this?

string myQuery = "select * from FP where FP.[Paid Amount] >= '100' ";

Note that => and >= are not the same.

By the way, if [Paid Amount] is a numeric column, you'll want to drop the single quotes, like this

string myQuery = "select * from FP where FP.[Paid Amount] >= 100 ";