Database - Introduction to SQL - Discussion

Hi, i think its true as * means anything or in any sequence.

You got confused i think. sql 92 wildcards are % and _ only. it's specified in 18th question of general questions section.Regarding *, in sql 92 it's used to select all columns. It's not a wild card in sql 92

For Sequence of character SQL use (%) wildcards not (*).(*) is used with SELECT for all Columns. Here in question they are talking about value of columns have sequence of character. Ex- you want name starting with 'J' and remaining name character will be 0 or any sequence of Character so,

Query like - SELECT Name from <Table-Name> where Name like 'J%';

You will get Name like - Jay, J, Jai any thing like.

Its about MS-Access. Not SQL-92.

According to me, it is correct answer because * is not wildcard symbol.

Right @Bhushan.

The wildcard asterisk (*) in SQL is generally used to represent all columns, not a sequence of characters.