select name from ship where where PATINDEX ('% %',name )>0

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.

Question Posted / sandeep modapathi

Answer Posted / sandeep modapathi

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to test a dml trigger in ms sql server?

989

How do I find my localdb version?

941

Define outer join in sql server joins?

892

What is the template in sql?

919

How to delete database objects with "drop" statements in ms sql server?

1035

What is difference between clustered and non clustered index?

923

What is sql server profiler trace data file?

1052

Explain “row_number()” in sql server with an example?

950

How many types of attribute relationships are there? : sql server analysis services, ssas

1002

Explain in details security in SQL azure?

121

Explain the properties of subqueries in sql server?

1019

What are triggers in ms sql server?

1105

how many clustered indexes can be created on a table? : Sql server database administration

1068

What is the query and subquery?

1027

Explain what is lock escalation?

989