Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
SQL query to search records
Joicy Sunny
May 23 2017 12:15 PM
294
Reply
tbl_Test contains the following records
Id Name
1 OIL FILTER COLLAR
2 FORK OIL SEAL KIT
3 IGNITION COIL
4 OIL FILTER ELMENT
5 ENGINE OIL
6 OILLION HOLDING TUBE
I need to select records where the Name contains the exact word "Oil"
that is, required output is
Id Name
1 OIL FILTER COLLAR
2 FORK OIL SEAL KIT
4 OIL FILTER ELMENT
5 ENGINE OIL
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Working With SQLCE for SCHOOL MANAGEMENT SYSTEM.
change the date in ssis package for XML file