>>>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?
Select * from Exhibit where Lower(LEFT(cWorkTitle, 2))="te"Is that any better?
SELECT * FROM Exhibit WHERE LOWER(LEFT(cWorkTitle, 2)) == "te"Kev