Keyword Search a single SQL Server table for multiple search terms and create a new table from results? I am not a database administrator. Most of my experience is with MySQL. However I think what I want to do is in the realm of possibility.

I want to text query a single large table in a SQL Server database for about 30 keyword terms. I then want the results to be dumped into a new table on the same database. I want the terms found to include entire field they were found in. (other items in row don't matter).

I am trying to produce data from the database to provide to a outside party. The table I want to search is to large to export to any format.

Is this possible?
Your search:

SELECT col 
  FROM dbo.existing_table
  WHERE col LIKE '%keyword1%'
     OR col LIKE '%keyword2%'
     ...;


To put the results into a new table:

SELECT col
  INTO dbo.new_table_name
  FROM dbo.existing_table
  WHERE col LIKE '%keyword1%'
     OR col LIKE '%keyword2%'
     ...;