Actually, you wouldn't want to do it this way. Since strings in dotnet are immutable, you are in reality building 4 separate strings with this operation. To do this properly, you should make sQuery of type Stringbuilder. And when you are ready to use the query do sQuery.ToString().

Here's a little discussion on this topic:

http://channel9.msdn.com/ShowPost.aspx?PostID=14932

>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.