[SQL] Difference between " and '

[Ruslan Zasukhin]

on 12/24/03 8:38 AM, Eric Forget at forgete at cafederic.com wrote:

> 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?

No.

By SQL standard ONLY single quotes should be used for string constants.

Does your Country field have flag Index by words?


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------