Select * from Exhibit where Lower(PADR(cWorkTitle,100))="te">Hi all,
>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?