Hi Caroline,
Try this:
select * from Exhibit where ( not empty(cWorkTitle) ) and ( lower(cWorkTitle)="te" )
>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?
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN
If a vegetarian eats vegetables, what does a humanitarian eat?