select name,year from ship where name like '%,%';

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 / suresh

Answer Posted / suresh

select name,year
from ship
where name like '%,%';

Is This Answer Correct ?

1 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What is the stuff?

1003

What are SSL and TSL protocols?

989

Do you know the cursor types?

1156

How many levels of sp nesting are possible?

1028

Explain about sql server login?

1088

How to concatenate two binary strings together?

1126

What is an execution plan?

1152

What is check constraint in sql server?

1002

What is difference between index seek vs. Index scan?

1155

What are Row versions of DataRow?

1034

Differentiate between a primary key and a unique key.

1073

What is the difference between join and inner join?

1013

How to configure odbc dsn with different port numbers?

1089

How many replicas are maintained for each sql azure db?

124

What are views in ms sql server?

1084