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

What is exclusive locks?

967

What are tables in sql server?

1048

what is hash nonclustered index

977

How to get a list of all tables with "sys.tables" view in ms sql server?

1041

Explain the cursor lock types?

1063

Can you explain various data region available in ssrs with their use?

977

What are the basic functions for master, msdb, model, tempdb databases?

1050

Can sql servers linked to other servers?

1052

Explain about Views?

1077

What is the default server name for sql server?

1182

How use inner join in sql server?

1141

is it important for a database administrator to understand the operating system and file access? : Sql server administration

1040

Can you explain powershell included in sql server 2008?

948

What is master database? : SQL Server Architecture

1028

What is snapshot parameter in ssrs?

155