>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?
That looks legal to me. You don't happen to have a variable with the same name?
Also, try to close all open tables first.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)