SQL query to select the records where name start with some specific character.

Hi

Greetings

The query will perform only MAXIMUM 3 Characters in [name] column, not for Morethan THREE characters...

It should be...

SELECT [name],roll FROM Student WHERE [name] LIKE 'AB%'

Please change the query / question

Cheers

You mentioned "It will display the records in which the name starts with AB."

But it will display the records in which the name is AB_.

Please modify your query to
the one suggested by Pandians
as

SELECT [name],roll FROM Student WHERE [name] LIKE 'AB%'

in order to fetch what is mentioned !!

Thanks for your correction. It is posted by mistake. Sorry for the mistake.