title: Regex statement in SQL Server
body: <p>I have certain column names that are named</p>
  
  <pre><code>car_model1
  car_model2
  bike_model1
  bike_model2
  </code></pre>
  
  <p>I'm trying to regex just the part before the "_" but my regex statement isn't working in SQL Server 2008.</p>
  
  <p>I have:</p>
  
  <pre><code>select COLUMN_NAME 
  from INFORMATION_SCHEMA.COLUMNS
  where table_name = 'dt_model_data'
    and COLUMN_NAME like '%([^\_]+)%'
  </code></pre>
  
  <p>This doesn't return anything but in python this regex statement works. Am I missing something?</p>
  
  <p>Thanks</p>