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

4 Answers
6839 Views
I also Faced
E-Mail Answers

Answer Posted / suresh

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

Is This Answer Correct ?

1 Yes

8 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

List the types of recovery model available in sql server?

972

what is a schema in sql server 2005? : Sql server database administration

1083

Where do we use trace frag?

1064

How do I know if localdb is running?

1001

What stored by the master?

1012

How to get a list of columns in a view using the "sp_columns" stored procedure?

1086

Explain time data type in sal server 2008?

970

How can I add Reporting Services reports to my application?

132

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1799

What is the function of inner join?

1127

How to select some specific columns from a table in a query in ms sql server?

1048

Why use “pivot” in sql server?

1182

We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

1446

Explain system views?

1133

How extra digits are handled with numeric data type literals?

1034