>I have an integer field Member.Numero and do this:
>
>
>SELECT * from Member WHERE Numero=1
>SELECT * from Member WHERE Numero='1'
>
>
>Why both SQL work? Isn't it suppose to give an error on the second one?
It implicity converts '1' to the higher precedence which is integer.
Take a look at this
Data Type Precedence (Transact-SQL)Integer has higher precedence than char.
If it's not broken, fix it until it is.
My Blog