In other words, views can be queries but can’t be updated. That said, the information in a view is always up to date, which implies that the view isn’t materialized when it’s defined.

Learn how to use the AND, OR, and NOT operators, and the IN, BETWEEN, and LIKE keywords, to filter data with SQL using multiple conditions.

I've got an Access 2003 database linked to a SQL Server 2000 database. In SQL Server (Enterprise Manager) - the field is listed as:Data Type: text, Length ...