title: Alternative to indexed view on text column
body: <p>I have a database table I don't own or control being loaded from another system - and all the fields are <code>Text</code> - so obviously it's useless for any queries performance-wise.</p>
  <p>I thought to solve the problem by creating an indexed view, which just converts every field to <code>int</code>, <code>date</code> or <code>varchar</code>...   But apparently you can't create an indexed view on a text field.</p>
  <p>I know I can do a create table as select... but that's a once off, and it won't automatically update if someone does another load into the underlying table.</p>
  <p>Is there any way I can make a live table without <code>text</code> columns from one with <code>text</code> columns?</p>