[SQL] Difference between " and '

[Eric Forget]

>>>> The only flag it has is indexed. The length is 2, in case it may impact:
>>> 
>>> Length of what is 2 ?
>>> 
>>>   String[2] ?
>> 
>> Yes, the max and real length of the field.
> 
> Then how you want to find long string
> 
>   where f = 'FR-xxx'
> 
> ?

'FR-xxx' is not hard coded. It could be, 'US', 'US-CA', 'US-NY', 'CA',
'CA-QC', etc. So, what I want to catch, is when both the variable I have and
the field are 'US' or 'CA' or 'FR', etc.

Éric

___________________________________________________________________

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

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