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.
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
what is datawarehouse?
How can we use ConnectorJ JDBC Driver with MS SQL?
How to list all login names on the ms sql server?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
What is nolock?
Mention the differences between having and where clause.
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What is the difference between varchar and varchar types?
You want to implement the one-to-one relationship while designing tables. How would you do it?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What is check constraint in sql server?
What is the difference between count and distinct count?
What is a full text index?
Define Joins?
What happens if null values are involved in arithmetic operations?