Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 4901 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
How to delete a login name in ms sql server?
What are character string data types in ms sql server?
Explain primary key in sql server?
Can we use custom code in ssrs?
What is snapshot report?
Can group functions be used in the order by clause in ms sql server?
What are wait types?
What is the purpose of the model database?
How to create “dependant” parameter “make, model, year”
How to write a query with a right outer join in ms sql server?
How to drop an existing table?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
How to delete all rows with truncate table statement in ms sql server?
Explain isolation levels that sql server supports?
What happens when converting big values to numeric data types?
