>>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?
>>cWorkTitle is a Memo field is that significant?
>
>Caroline, since cWorkTitle is a Memo, perhaps you should try code like

Select * from Exhibit where Lower(LEFT(cWorkTitle, 2))="te"

Is that any better?

Nope that still includes all the empty ones!