SQL - combine results of 2 fields to 1. 2

[teksecrets]

Hi,
I'm trying to create a select statement to combine the results of 2 fields into 1.

For example,
I have 2 fields: First Name, Last Name. I'd like to combine so my results to show First Name Last Name in the same field.

Field 1 Field 2
Jane Smart
Results: Jane Smart.

How should the SQL statement look?

 

[sunila7]

Hi,

Try this SQL

Select firstname + ' ' + Lastname FullName from Tbl

Sunil

 

[teksecrets]

Thanks so much for responding so quickly! Yes that worked for the names.
How would I modify the select statement to make it work with numbers, but I don't want to add up the 2 numbers in each field.
For example:
Field 1 Field 2
15 20
I'd like the results to show:
15.20

This would mean I need to add a . between the 2 fields.

Thanks again for your help!

 

[swampBoogie]

select cast(field1 as varchar) + '.' +
cast(field2 as varchar) from t

 

[teksecrets]

THANKS SO MUCH! YOU GUYS ARE ABSOLUTELY AWESOME!