If suppose in a table ship(name,year),find ship name having
first and last name(i.e having space in between)
ex: SAINT LOUIS,JET LAKE.
- 4 Answers
- 5871 Views
- I also Faced
- E-Mail Answers
Answer Posted / sandeep modapathi
select name from ship where where PATINDEX ('% %',name )>0
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to use clusters?
what is datawarehouse?
Explain the difference between control flow and data flow?
Mention what are the different types of ssrs reports?
Explain about system database?
Can you explain important index characteristics?
How can a user-defined datatype be created?
Explain about protocol layer present in SQL server?
How do I find my localdb version?
What is instead of dml trigger?
How do you delete duplicate rows in sql server?
what is blocking? : Sql server database administration
What is difference between delete and truncate commands?
What is a ddl statement?
How do you Implement SSIS Packages in your Project?
