Andrew Lee
Andrew Lee

Reputation: 19

What does 'tableName.column like '?*'' represent Microsoft Access

Something like

SELECT * FROM table WHERE table.column LIKE '?*'

What does that mean?

Upvotes: 0

Views: 53

Answers (1)

gaganshera
gaganshera

Reputation: 2639

The question mark ? character will only search for a single character, and asterisk * character will search for all characters.
This combination will search for table.column containing atleast 1 character.

Upvotes: 1

Related Questions