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