title: How to convert Number Datatype to Text Datatype - ODBC Query - C#
body: <p>I am developing a Windows Forms Application in C# with 2.0 being the underlying .Net Framework. I use .Net Framework Data Provider for ODBC in order to connect to a specific access database. </p>
  
  <p>I have a field say "NumberColumn" with 'Number' datatype &amp; another field say "StringColumn" with 'Text' datatype in one of the tables present in the database. I have to concatenate the values present in the two fields in this format ("StringColumn-NumberColumn"). </p>
  
  <p>I tried using the convert function "CStr" in the query to convert the number column and append with the string column but am getting an exception "Invalid scalar function CStr".</p>
  
  <p>Presently, am doing this concatenation in the DataTable level which I feel is expensive considering the huge amount of data. How could I achieve the concatenation in the specified format while querying the data?</p>