Clipped More THen Once Columns via SQL
--------------Boundary-00=_GHQ0MY50000000000000 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi=0D =0D I'm using IDS 7.31 in Linux OS.=0D =0D Is there away in SQL Select statement where I can clip/combine 2 or more columns as one single output.=0D =0D Example :-=0D =0D Table : tmp_cbpload=0D =0D Fields : tbld_company char(4)=0D tbld_batchid char(8)=0D tbld_payee char(70)=0D tbld_icacno char(14)=0D tbld_voucher char(12)=0D tbld_amount decimal(16,2)=0D =0D How can i combine tbld_payee and tbld_icacno to be one single output in select statement.=0D I thought i can used below command but it gave me an error :-=0D select tbld_payee || tbld_icacno from tmp_cbpload where . . . .=0D =0D Need some advise.=0D =0D =0D Thanks --------------Boundary-00=_GHQ0MY50000000000000 Content-Type: Text/HTML; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-= 1"> <META content=3D"IncrediMail 1.0" name=3DGENERATOR> <!--IncrdiXMLRemarkStart> <IncrdiX-Info> <X-FID>FLAVOR00-NONE-0000-0000-000000000000</X-FID> <X-FVER>4.0</X-FVER> <X-CNT>;</X-CNT> </IncrdiX-Info> <IncrdiXMLRemarkEnd--> </HEAD> <BODY style=3D"BACKGROUND-POSITION: 0px 0px; FONT-SIZE: 12pt; MARGIN: 5px= 10px 10px; FONT-FAMILY: Arial" bgColor=3D#ffffff background=3D"" scroll=3D= yes ORGYPOS=3D"0"> <TABLE id=3DINCREDIMAINTABLE cellSpacing=3D0 cellPadding=3D2 width=3D"100= %" border=3D0> <TBODY> <TR> <TD id=3DINCREDITEXTREGION style=3D"FONT-SIZE: 12pt; CURSOR: auto; FONT-F= AMILY: Arial" width=3D"100%"> <DIV> <FONT face=3D"Comic Sans MS" size=3D2>Hi</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2>I'm using IDS 7.31 in Linux OS= =2E</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2>Is there away in SQL Select st= atement where I can clip/combine 2 or more columns as one single output.<= /FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2>Example :-</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2>Table : tmp_cbpload</FONT></DI= V> <DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2>Fields : tbld_company ch= ar(4)</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2> = tbld_batchid = char(8)</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2>  = ; tbld_payee char(= 70)</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2> = tbld_icacno = char(14)</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2> = tbld_voucher char(12)</F= ONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2> = tbld_amount decima= l(16,2)</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2>How can i combine tbld_payee a= nd tbld_icacno to be one single output in select statement.</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2>I thought i can used bel= ow command but it gave me an error :-</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2> select tbld= _payee || tbld_icacno from tmp_cbpload where . . . .</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2>Need some advise.</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2>Thanks</FONT></DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV> <DIV><SPAN style=3D"FONT-SIZE: 10pt"><FONT size=3D1><SPAN style=3D"FONT-S= IZE: 10pt"><BR style=3D"mso-special-character: line-break"><?xml:namespac= e prefix =3D o ns =3D "urn:schemas-microsoft-com:office:office" /><o:p></= o:p></SPAN></FONT> </DIV></SPAN></TD></TR> <TR> <TD id=3DINCREDIFOOTER width=3D"100%"> <TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"100%"> <TBODY> <TR> <TD width=3D"100%"></TD> <TD id=3DINCREDISOUND vAlign=3Dbottom align=3Dmiddle></TD> <TD id=3DINCREDIANIM vAlign=3Dbottom align=3Dmiddle></TD></TR></TBODY></T= ABLE></TD></TR></TBODY></TABLE><SPAN id=3DIncrediStamp><SPAN dir=3Dltr><A= href=3D"http://www.incredimail.com/index.asp?id=3D54475"><IMG alt=3D"Add= FUN to your email - CLICK HERE!" hspace=3D0 src=3D"http://www2.incredima= il.com/contents/stamps/imstp_emo_en.gif" align=3Dbaseline border=3D0></A>= </SPAN></SPAN></BODY></HTML> --------------Boundary-00=_GHQ0MY50000000000000--