We help IT Professionals succeed at work.
Get Started

SQL Server 2008 Express - How to find a record in a table with a specific text in one of its field

ZKM128 asked
Last Modified: 2012-08-15

I am trying to find a record in my SQL Server 2008 express database TABLE object.
I am trying to find a record with the text "Jack" in the first name field in a table named students.
I have opened the table in SQL Server 2008 management studio by right clicking the table object and clicking 'Edit Top 1000 rows'.

Edit Top 1000 rows
Then I tried to select the 'FirstName' table column heading using the mouse but I couldn't - I actually wanted to select the table header then press Ctrl+F key to open the Find/Search dialog box and search for the text "Jack" in the first name field. This method of finding a record with a specific text in a field worked fine in MS Access.

Couldn't select table column header
So, then I tried to open the table by right clicking the table object and clicking 'Select Top 1000 rows'.

Select Top 1000 rows
Luckly I could select the First name column. However when I pressed the Ctrl+F key and searched for the text "Jack" in the first name field, SQL Server management studio says Text not found.

Searching for a record using Ctrl   F
Text not found
So, my question is, Is there a simple way of finding a record in SQL server database table containing a specific word without creating a view/query? I want to quickly find a record and edit the record directly, rather than having to create a new view in SQL Server management studio to search for the record.
Watch Question
This problem has been solved!
Unlock 3 Answers and 5 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE