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

Explain how many normalization forms?

1037

What is the log shipping?

1005

Explain the concept of recursive stored procedure.

963

How to create a store procedure with encryption?

1006

How to create stored procedures with parameters in ms sql server?

1079

How do I run a trace in sql server?

984

Is it true, that there is no difference between a rule and a check constraint?

1058

What is tablix?

162

Can we perform backup restore operation on tempdb?

1017

What is server-level principal?

122

what is package and it uses and how can u call a package

2014

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1889

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1070

What is built-in function?

1008

How we create SQL Server 2005 Reporting Services ? Give me Sample

1992