>>>I'm just trying to do this in the DE now, and whenever the
where is a Memo field I get the empty ones as well.
>>>
>>>I must be doing something wrong?
>>
>>Oh, I see. See SET EXACT ON in the help.
>>
>>You may be better off asking for left(MyMemoField,2) = "te" in this case.
>>
>>Hilmar.
>
>In the Help it says
>"" = "ab" is no match
>Is this not my case (comparing an empty string to something)?
You are right - it seems I confused left and right in this case.
I think that the SELECT command works a little different here. Perhaps you should still try with left(MyMemo, 2) = "te".
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)