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

What are examples of triggers?

1060

What are system databases into sql server (2005/2008)?

985

What are the 2 types of classifications of constraints in the sql server?

1101

How can sql server instances be hidden? : sql server security

1118

What do you understand by a stored procedure?

1074

What is user-defined inline table-valued function?

927

Which are the olap features?

940

What is the difference function and stored procedure?

1033

What is a cache in ssrs?

134

Does partitioning improve performance sql server?

953

What is the purpose of forms?

937

What stored by the tempdb ? : sql server database administration

1031

Can a table have 2 primary keys?

968

Tell me about builtinadministrator?

981

How exceptions can be handled in sql server programming?

995