TRY THIS: SELECT FIRSTNAME +'-'+LASTNAME FROM 'TABLENAME�

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 / monal

3 Answers
4752 Views
I also Faced
E-Mail Answers

Answer Posted / monal

TRY THIS:
SELECT FIRSTNAME +'-'+LASTNAME FROM 'TABLENAME'

Is This Answer Correct ?

7 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can you please explain the difference between function and stored procedure?

961

How to remove duplicate rows from table except one?

941

What is format parameter in ssrs?

136

How to insert multiple rows with one insert statement in ms sql server?

1058

Differentiate between mongodb vs. Sql server?

1035

How to make a remote connection in a database?

927

What is built-in/administrator?

958

What are pessimistic lock and optimistic lock?

1001

What is the difference between writing data to mirrored drives versus raid5 drives

873

Can You Use Data Mining Models In Ssrs?

139

What is difference between temp table and cte?

963

How to implement service broker?

923

what is bit datatype? : Sql server database administration

866

How to use old values to define new values in update statements in ms sql server?

1169

What is collation sensitivity? Explain different types.

964