What keyword does an SQL SELECT statement use for a string search?

What keyword does an SQL SELECT statement use for a string
search?

Question Posted / guest

2 Answers
7245 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What keyword does an SQL SELECT statement use for a string search?..

Answer / sunil1405

SELECT FNAME WHERE FNAME LIKE 'S%';

Is This Answer Correct ?

6 Yes

0 No

What keyword does an SQL SELECT statement use for a string search?..

Answer / kirtish srivastava

Like is used with where clause to search,update, and delete a record using wild cards.

Example:-
To Search;-

select * from Employee where Name like 'a%'

Note;- Search all records whose employee name is stared from a character.

To Update:-

update Employee set Name='amit' where Name like 'a%'

update all records with name amit whose employee name is started from a character.

To Delete:-

delete from Employee where Name like 'a%'

Delete all records whose employee name is started from a Character.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer