SQLServerCentral / Discuss Content Posted by Randy Dyess / Article Discussions / Article Discussions by Author / Problem with varchar return value with osql / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 04:54:39 GMT20RE: Problem with varchar return value with osqlhttp://www.sqlservercentral.com/Forums/Topic513621-84-1.aspxHi I have the same issue. I get the same below error. Can someone help?osql: Error converting exit value.Tue, 08 Mar 2011 02:07:39 GMTVickyWinnerProblem with varchar return value with osqlhttp://www.sqlservercentral.com/Forums/Topic513621-84-1.aspxHi everybody,I'm trying to insert an osql command within a DOS batch file (which contains DOS commands) :osql -S Server -U User -P PassWord -Q "select top 1 column1 from table1 a, table2 b where b.id=a.id"I would like to use the value of the column1 in the continuation of my batch file.I tried by using exit :osql -S Server -U User -P PassWord -Q "exit(select top 1 column1 from table1 a, table2 b where b.id=a.id)"But my problem is that the column1 is not an integer but a varchar, so I have an error message :osql: Error converting exit value.Any idea ? Many thanks for your help. :(Mon, 09 Jun 2008 04:55:21 GMTabdel-774383