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?