SQL Help

Sep 01, 2005 1 Replies

I am trying to run a query in SQL to find the following:



select firstname, lastname, emailaddress, accountbalance from customer where accountbalance


remove the quotes from the where clause - accountbalance is a MONEY field, '0' is a string value

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required