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
Answers were Sorted based on User's Feedback
Answer / monal
TRY THIS:
SELECT FIRSTNAME +'-'+LASTNAME FROM 'TABLENAME'
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / sudhakar
use replace function
select replace(a,' ','-') from sub_string
Is This Answer Correct ? | 1 Yes | 1 No |
What are the different types of queries?
What is inline variable assignment?
What is unique key constraint?
what are cursors? : Sql server database administration
How many types of triggers are there?
if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?
What is plan freezing?
How to tune a stored procedure?
What is normalization 1nf 2nf 3nf?
What does nvl stand for?
How can you control the amount of free space in your index pages?
Explain transaction server isolation?