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
4849 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

Give a example to search fr a string in all stored procedure in sql server.

964

What is snapshot replication?

1037

What is query optimizer in sql server?

992

How to get the definition of a user defined function back?

1029

Explain about Normalization?

1038

Is INSTEAD OF trigger directly applicable to Table ?

997

What are the limitations/drawbacks or ssrs 2008 r2?

139

If user is owning any SQL Objects, can we drop that user

2050

Explain the use of keyword with encryption. Create a store procedure with encryption?

933

Is foreign key unique?

983

What are the different ways you can create databases in sql server?

1079

why would you call update statistics? : Sql server database administration

1061

What is the difference between Triggers and Stored Procedure?

1078

What are the limitations in ssrs on sql server express edition?

186

what is dbcc? : Sql server database administration

1010