<div>
CREATE TABLE [tablename] (<br />
&nbsp; &nbsp; [fname] [varchar] (50) &nbsp;,<br />
&nbsp; &nbsp; [lname] [varchar] (50) &nbsp;,<br />
&nbsp; &nbsp; [name] AS (isnull(([fname] + ' '),'') + isnull([lname],'')) <br />
) ON [PRIMARY]<br />
GO<br />
<br />
<br />

</div>


CREATE TABLE [tablename] (
    [fname] [varchar] (50)  ,
    [lname] [varchar] (50)  ,
    [name] AS (isnull(([fname] + ' '),'') + isnull([lname],''))
) ON [PRIMARY]
GO




<div>
I am new to SQL to server can this be done within the table design using the formula field, sorry im used to MS Access<br />

</div>


I am new to SQL to server can this be done within the table design using the formula field, sorry im used to MS Access


<div>
I think You should have split the points <br />
:(
</div>


I think You should have split the points
:(

<div>
Sorry aneeshattingal quite new to this and did not think about that. &nbsp;I will think more carefully next time
</div>


Sorry aneeshattingal quite new to this and did not think about that.  I will think more carefully next time

<div>
That's ok, I think you should read this first<br />
<br />
<a href="https://www.experts-exchange.com/help.jsp#hi19" rel="ugc">https://www.experts-exchange.com/help.jsp#hi19</a><br />
<a href="https://www.experts-exchange.com/help.jsp#hi18" rel="ugc">https://www.experts-exchange.com/help.jsp#hi18</a><br />
<a href="https://www.experts-exchange.com/help.jsp#hi73" rel="ugc">https://www.experts-exchange.com/help.jsp#hi73</a>
</div>


That's ok, I think you should read this first

https://www.experts-exchange.com/help.jsp#hi19 [https://www.experts-exchange.com/help.jsp#hi19]
https://www.experts-exchange.com/help.jsp#hi18 [https://www.experts-exchange.com/help.jsp#hi18]
https://www.experts-exchange.com/help.jsp#hi73 [https://www.experts-exchange.com/help.jsp#hi73]

<div>
<div class="content wysiwyg-content">
I have two fields in my table - firstname and surname - I would like to have a field named whole name and the value of the previous fields I mentioned put into this as a default value.<br />
<br />
How can I go about doing this?
</div>
</div>


I have two fields in my table - firstname and surname - I would like to have a field named whole name and the value of the previous fields I mentioned put into this as a default value.

How can I go about doing this?

How to use SQL formula in table design?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.