SELECT * INTO new_table FROM old_table WHERE last_name LIKE 'Ja%'; GO The LIKE keyword allows you to filter results based on a wildcard expression. In this example, Transact-SQL will create a new ...