title: Default random 10 character string value for SQL Server column
body: <p>I have a column <code>rndm</code> in my table [guests]. Now, for the field <code>Default value or Binding</code> for the table, whenever a new row is inserted I want to automatically insert a 10-character random string into this column as the default value.</p>
  
  <p>This random string may not contain special characters, only characters from <code>a-zA-Z0-9</code>. What is the best approach to achieve this?</p>
  
  <p>To be clear: I don't want to generate this random string in my .NET code, I want it to be generated within SQL Server. And I want to paste this string generation directly into the field <code>Default value or Binding</code> for the table, so not a separate SQL statement. So for example like it works when pasting <code>getdate()</code> into the field  <code>Default value or Binding</code>.</p>
  
  <p><img src="https://i.stack.imgur.com/2syAO.png" alt="enter image description here"></p>