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

explain databases and sql server databases architecture? : Sql server database administration

936

What is Federation and Federation Member?

What is transactional replication?

943

How to declare and use cursor variables?

1135

How to generate create view script on an existing view?

969

What is difference between after and before?

1058

How can we check the sql server version?

1031

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1014

How to loop through result set objects using mssql_fetch_array()?

1048

What is normalization and its types?

999

Explain insert into select statement?

927

which backup strategy you are following at ur company

2132

Tell me what is a linked server?

1024

What is a partitioned view?

972

What is transact-sql language?

1052