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

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

755

Explain the etl (extraction, transformation, and loading)?

724

What is data compression?

734

What is dbcc?

888

What is the openxml statement in sql server?

728

Explain what is scheduled job and how to create it?

716

What is difference between inner join and join?

733

What are the dmvs?

767

Can you explain what is indexed view? How to create it?

717

how to take backup bcp out for a column in table in sql server?

1830

How does normalization work?

689

What Are the Main Features of SQL Azure?

109

How to use subqueries with the in operators in ms sql server?

747

What is bcp? When does it use?

672

Explain what is analysis service repository?

708