[SQL] Difference between " and '

[Eric Forget]

Hi,

I found something in an SQL query:

    SELECT RecID FROM Table WHERE Country = 'FR-M'

and

    SELECT RecID FROM Table WHERE Country = "FR-M"

do not behave the same. The first one will accept countries equal to "FR"
but not the second. Is it a normal SQL behavior?

Éric

___________________________________________________________________

 Eric Forget                       Cafederic
 ForgetE at cafederic.com             <http://www.cafederic.com/>

 Fingerprint <86D5 38F5 E1FD 5D9C 71C3  BAA3 797E 70A4 6210 C684>