title: How to concat a string with an ID in SQL Server?
body: <p>This is my T-SQL code. </p>
  
  <pre><code>CREATE TABLE [dbo].[AspNetUsers] 
  (
      [Id]            NVARCHAR (128) NOT NULL,
      [Email]         NVARCHAR (256) NULL,
      [PasswordHash]  NVARCHAR (MAX) NULL,
      [UserName]      NVARCHAR (256) NOT NULL,
      [FirstName]     NVARCHAR(50) NOT NULL DEFAULT /*what goes in here*/, 
      [LastName]      NVARCHAR(50) NOT NULL DEFAULT 'LastName', 
  
      CONSTRAINT [PK_dbo.AspNetUsers] 
          PRIMARY KEY CLUSTERED ([Id] ASC)
  );
  GO
  
  CREATE UNIQUE NONCLUSTERED INDEX [UserNameIndex]
      ON [dbo].[AspNetUsers]([UserName] ASC);
  </code></pre>
  
  <p>I want <code>FirstName</code> and <code>LastName</code> to be not allowed as nulls, but I keep getting an error saying that I should either add defaults or either I should allow them to have nulls (which I don't want to do at all). So I thought I would add defaults. I want to take the Id and concat it with the word <code>FirstName</code> and <code>LastName</code> for the respective columns.</p>
  
  <p>For example if my <code>Id</code> is 345, I want my defaults for <code>FirstName</code> and <code>LastName</code> to be (of nvarchar type) <code>345FirstName</code> and <code>345LastName</code> respectively.</p>
  
  <p>So how do I do this?</p>