Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-12-03 : 07:59:47
|
| Esmeralda writes "I do a bulk copy from a text file to a table on my DB, using SQL-DMO, the problem: at the end of each row (Col11) appears an end caracter like a tab, so, when I do my query IE send this message:Microsoft OLE DB Provider for SQL Server (0x80040E07)Error al convertir el tipo de datos varchar a float.Atenango.asp, línea 290rs.Open "SELECT Col001, AVG(CONVERT(float, Col011)) AS Expr1 FROM Atenango_" & amo & mesn & " WHERE (Col001 LIKE '" & amo & "-" & mesn & "-" & dia & "%') GROUP BY Col001", conn, 3What can i do to delete this end character usin SQL-DMO?is it possible use a trim function inside the query?" |
|
|
|
|
|
making a trim