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.
Answer Posted / sandeep modapathi
select name from ship where where PATINDEX ('% %',name )>0
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to edit table in sql server 2017?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
How do I schedule a sql server profiler trace?
What is sql server programming?
How do I run a trace in sql server?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
How to get a list all databases on the sql server?
What is 'write-ahead log' in sql server 2000 ?
What is collation sensitivity?
Differentiate between delete and truncate.
What is the difference between an index and a unique index?
Can coalesce return null?
What are the new features of sql server 2012 reporting service?
What is the meaning of sql server?
what are the three command line utilities and what are their primary functions?