SkysLastChance Posted January 10, 2017 Share Posted January 10, 2017 (edited) SELECT ProcedureID,BatchDate,ServiceDate,ProcedureDescription,Amount,BillingProviderID FROM dbo.PbrChargeTransactions WHERE BillingProviderID = 'SEU.JO' and ServiceDate Between '2016-01-01 and 2016-12-31' and Amount > '0' ORDER BY ServiceDate I am using 2012 server and was wondering why my > sign is not working? I get Msg 102, Level 15, State 1, Line 5 Incorrect syntax near '>'. Edited January 30, 2017 by SkysLastChance Life's simple. You make choices and you don't look back. Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now