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 is 2nf normalization form?
What are the differences between clustered and non-clustered index?
What is unpivot?
i need some interview questions on sql server developer plz any onee send some links.
How to find the version of sql server? : sql server database administration
What are the different types of replication are there in sql server 2000?
What is difference between standardization and normalization?
What are cursors in ms sql server?
Write a SQL query to make a column as unique?
Why can there be only one clustered index and not more than one?
Can you explain powershell included in sql server 2008?
Is there any difference between the primary key and unique key?