Hi Perry,
That was interesting to read and something I did not know. At this level it wouldn't have made any difference based on the article but using this method could be deemed a bad habbit I guess. Thanks for the insight.
Tim
>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.
Timothy Bryan