In addition to those suggestions you can always do this:

string sQuery = "SELECT ordinal_position, column_name, data_type, is_nullable ";
sQuery += "FROM informatin_schema.Columns "
sQuery += "WHERE table_name LIKE '%avClients%' ";
sQuery += "ORDER BY ordinal_position";

No reason to, but it is an option and sometimes useful.
Tim

>How do I code this query?
>
>

>
> string sQuery = "SELECT ordinal_position, column_name,data_type, is_nullable
>                FROM information_schema.Columns WHERE table_name LIKE '%avClients%'
>	            ORDER BY ordinal_position"
>
>

>
>I'm not sure how to continue or break each line.