[SOLVED] Noob Question

[SkysLastChance]

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

[SkysLastChance]

I figured it out the problem was here

and ServiceDate Between '2016-01-01 and 2016-12-31'  - Wrong

and ServiceDate Between '2016-01-01' and '2016-12-31'  - Right

[water]

I know nothing about SQL but shouldn't be

and Amount > '0'

changed to

and Amount > 0

for a numeric comparison?

[SkysLastChance]

I know close to nothing. I am just starting to pick it up again. I tried it both ways and it works. I wonder if there is a downside to eitherway. 

[TheDcoder]

  On 1/10/2017 at 10:40 PM, SkysLastChance said:

I wonder if there is a downside to eitherway. 

Expand  

I think the string comparison converts the character to its decimal equivalent before comparing... just a guess, I have not done any SQL

[steveeye]

the string will work both ways . on ints and decs.