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 / challa yerriswamy

Answer Posted / challa yerriswamy

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

Is This Answer Correct ?

10 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Is truncate autocommit?

938

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

952

Write the SQL query to drop, truncate and delete table.

973

Explain go command in sql server?

1040

How to delete existing rows in a table?

1162

Define left outer join in sql server joins?

965

what are constraints? Explain different types of constraints? : Sql server database administration

989

How to convert binary strings into integers in ms sql server?

1030

What is the data type of time?

963

Determine when to use stored procedure to complete sql server tasks?

1054

Explain indexing and what are the advantages of it?

1028

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1108

do views contain data ?

973

List the various tools available for performance tuning?

887

What is TDS(Tabular Data Stream) Gateway?

121