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

SELECT * FROM Exhibit WHERE LOWER(LEFT(cWorkTitle, 2)) == "te"

Kev