[SQL] Difference between " and '

[Ruslan Zasukhin]

on 12/26/03 6:41 PM, Eric Forget at forgete at cafederic.com wrote:

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

Eric,

Please, just send me db,
And send me searches you want to make
    and what result you expect for each search
        and what you get.

Then I will check.

Let table will have just few records.
Okay?

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