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'.
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.
So, then I tried to open the table by right clicking the table object and clicking '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.
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.