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
- 4848 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
What is unique key constraint?
What are the types of subquery?
Can sql server be linked with other servers like oracle?
What is the use of set nocount on/off statement?
Working with TLogs
how you can get the list of largest tables in a database? : Sql server administration
What do you need to connect php to sql server?
What is the command used to check locks in microsoft sql server?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
Does table partitioning improve performance?
List out the different types of locks available in sql server?
Mention the different types of triggers?
Does the unique constraint create an index?
What is sql server english query?
If the job running very slow what is the action you do
