SQL Help

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

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

Reply to
Nick
Loading thread data ...

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

Reply to
Glenn Adams [MVP - Retail Mgmt]

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.