title: SQL Select query to pick the field value which has more than one empty space?
body: <p>In my LastName Column, I have either one name or two names. In some records, I have more than one empty space between the two names.</p>
  
  <p>I will have to select the records which has more than one empty space in the field name.</p>
  
  <pre><code>declare @nam nvarchar(4000)
  declare @nam1 nvarchar(4000)
  
  set @nam = 'sam' + ' ' + 'Dev'
  set @nam1 = 'ed' + ' ' +  ' ' + 'Dev'
  </code></pre>
  
  <p>In the sample query, i expect the output value should be @nam1.</p>