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

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

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

Abhisek Panda

Found interesting? Add this to:

| More | Bookmark It

Responses
Posted by: Pandians \| Posted on: 3/1/2010 \| Level: Silver \| Status: [Member] [MVP] \| Alert Moderator 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 Cheers www.SQLServerbuddy.blogspot.com iLink Multitech Solutions
Posted by: Puneet20884 \| Posted on: 3/3/2010 \| Level: Bronze \| Status: [Member] \| Alert Moderator 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 !! Best Regards, Puneet Sharma - Infosys Pune, India
Posted by: Abhisek \| Posted on: 3/3/2010 \| Level: Bronze \| Status: [Member] \| Alert Moderator Thanks for your correction. It is posted by mistake. Sorry for the mistake. Abhisek Panda

>> Write Response - Respond to this post and get points

More codes snippets
	Query to change the datatype of a table. Code snippet to populate Dataset from XML XAML Code to work with Expander Control XAML code to create an image button XAML code to create a button with LineargradientBrush. XAML code for a simple polygon Simple Animation In WPF XAML code to rotate a button on click. Button Control With Textbox Submit Code \| More ...

Responses