How do i query the size of a field in Access?

[Guest_imported]

Hello,

I was wondering if anyone knows how to write a query that only returns rows with a field of a certain number of characters? Can this be done in a select query?

e.g. "select * from tblBooks Where sizeof(txtBookTitle) > 100"

something like that to select only books with titles longer than 100 characters?

Any help would be greatly appreciated,

thanks

jonty

 

[tomschafer]

select * from tblBooks Where Len(txtBookTitle) > 100