use replace function select replace(a,' ','-') from s

you are provided with the single table having say 4 col ie
fname lname age city , now the all records with displying of
only fname and lname is required but in this format say my
name is abhay khanna it will come like this
abhay-khanna
rahul-roy
gaurav-singh
the above format is required

Question Posted / sudhakar

3 Answers
5025 Views
I also Faced
E-Mail Answers

Answer Posted / sudhakar

use replace function
select replace(a,' ','-') from sub_string

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is an execution plan?

1240

What are sub reports?

208

What is RAID? What are the different types of RAID configurations?

1183

What is the difference between seek predicate and predicate?

1111

What are different types of data sources?

1085

What is the optimization being performed in oracle and SQL Server?

1099

What is the difference between an index and a unique index?

1048

How to enable tcp/ip protocol on a sql server?

1214

What is the syntax for encrypting a column in SQL Server?

1175

Define Wed Edition in SQL Azure?

102

How many cores do I need for sql server 2016?

953

What are the approximate numeric data types?

988

What is ms sql server index?

1152

How many non clustered indexes there can be on table ?

962

System requirements for sql server 2005 express edition?

1070