Quote:
Originally Posted by nickole
Hi,
I am new into SQL, How to use SELECT statement to fetch records based on a partial match in a text field.
Say for ex., I want to retrieve all names with has the "William" in any part of the name field. How to write a query for the above Scenario?
Thanks in advance.
|
select ename from table name
where ename like'%William%';
write the table name from where u have to extract the data