Have got a Function that fills a DataSet:<BR><BR> Public Function GetEvents(ByVal moduleId As Integer) As DataSet<BR><BR> ' Create Instance of Connection and Command Object<BR> Dim myConnection As New SqlConnection(ConfigurationSettings.AppSettings("connectionString"))<BR> Dim myCommand As New SqlDataAdapter("GetEvents", myConnection)<BR><BR> ' Mark the Command as a SPROC<BR> myCommand.SelectCommand.CommandType = CommandType.StoredProcedure<BR><BR> ' Add Parameters to SPROC<BR> Dim parameterModuleId As New SqlParameter("@ModuleId", SqlDbType.Int, 4)<BR> parameterModuleId.Value = http://aspmessageboard.com/archive/index.php/moduleId<BR> myCommand.SelectCommand.Parameters.Add(parameterMo duleId)<BR><BR> ' Create and Fill the DataSet<BR> Dim myDataSet As New DataSet()<BR> myCommand.Fill(myDataSet)<BR><BR> ' Return the DataSet<BR> Return myDataSet<BR><BR> End Function<BR><BR>What i need to do is crop the string to 100 characters in the Description Column of each row in the DataTable that is created in myDataSet.<BR><BR>How do i do this?<BR><BR>cheer for any replies,<BR><BR>siuse LEFT(field,100) as field in your select area of sql statement<BR><BR>T