>>Hi all,
>>
>>Could someone please tell me what I'm doing wrong with this select statement.
>>

>>Select * from Exhibit where Lower(cWorkTitle)="te"
>>

>>This correctly gets all the exhibits with a cWorkTitle starting with "te" but it also get any records that have a blank cWorkTitle, why should that be?
>>
>>Thanks in anticipation.
>>
>>UPDATED:
>>cWorkTitle is a Memo field is that significant?
>
>That looks legal to me. You don't happen to have a variable with the same name?
>
>Also, try to close all open tables first.
>
>Hilmar.

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?