Odd SQL Search Behavior

[Chuck Pelto]

So....

...should I enclose the text, with spaces and/or hypens, in 
double-quotes (") or single-quotes (')?

And what if I'm using a variable? This was the case in my experienced 
problem. I had a variable that I was using that held the text I was 
looking for in the table.

Regards,

Chuck

On Feb 4, 2005, at 1:10 PM, Ruslan Zasukhin wrote:

> On 2/4/05 10:02 PM, "Chuck Pelto" <cbpelto at pcisys.net> wrote:
>
>> Morning Ruslan,
>>
>> Hope all is going well with you.
>>
>> Please give me an example of "wrap value by '"'".
>
> WHERE fld = 'text you search'
>
> -- 
> 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
> -------------------------------------------------------------
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>