Current location - Quotes Website - Team slogan - How can SQL statements query all records in the ACCESS database whose string field length is equal to a certain value?
How can SQL statements query all records in the ACCESS database whose string field length is equal to a certain value?
SQL statement is used to query all records whose string field length is equal to a certain value: SQL=SELECT * From table name Where? Len (character column name) = length value

Structured Query Language (SQL for short) is a special programming language, a database query and programming language, which is used to access data, query, update and manage relational database systems.

The LEN () function of SQL, which returns the length of the value in the text field.

The SELECT statement is used to select data from a table. The results are stored in a result table (called a result set).

The * sign in the SELECT * From tab indicates that all field values have been obtained. For specific fields, you can use:

Select column name 1, column name 2 and column name 3 from the table.