topic Extract varchar from sqlserv in QlikView https://community.qlik.com/t5/QlikView/Extract-varchar-from-sqlserv/m-p/220625#M73524 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I am doing a extract from sqlserver and in the table has a column varchar2(6) and has two registers where this column has '00300' and other has '300', so when the qlikview doing the select set both as 00300. How can avoid this, because like this the result is wrong.</P><P>thanks</P><P>Geny</P></BODY></HTML> Mon, 18 Apr 2011 19:36:22 GMT 2011-04-18T19:36:22Z Extract varchar from sqlserv https://community.qlik.com/t5/QlikView/Extract-varchar-from-sqlserv/m-p/220625#M73524 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I am doing a extract from sqlserver and in the table has a column varchar2(6) and has two registers where this column has '00300' and other has '300', so when the qlikview doing the select set both as 00300. How can avoid this, because like this the result is wrong.</P><P>thanks</P><P>Geny</P></BODY></HTML> Mon, 18 Apr 2011 19:36:22 GMT https://community.qlik.com/t5/QlikView/Extract-varchar-from-sqlserv/m-p/220625#M73524 2011-04-18T19:36:22Z AW:Extract varchar from sqlserv https://community.qlik.com/t5/QlikView/Extract-varchar-from-sqlserv/m-p/220626#M73525 <HTML><HEAD></HEAD><BODY><P>I hope I have correctly understood the question<BR /><BR />try this!<BR /><BR /></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />...<BR />TEXT(yourColumn) as yourColumn<BR />...<BR /></PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Mon, 18 Apr 2011 20:52:40 GMT https://community.qlik.com/t5/QlikView/Extract-varchar-from-sqlserv/m-p/220626#M73525 2011-04-18T20:52:40Z