fixed and string concatenation
Валерий Жученко <[email protected]> Wed, 17 Sep 2003 16:46:43 +0500
| Newsgroups | gmane.comp.db.sapdb.general |
|---|---|
| Message-ID | <055401c37d11$5deee840$ba19a8c0@wrk> |
This is a multi-part message in MIME format. ------=_NextPart_000_0551_01C37D3B.46A05140 Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: quoted-printable Hi. How I can receive the following result from select '>' || fixfld || '<' from table >8< Where fixfld =3D 8 for example and fixfld is fixed (5,2). I receive >8.00< ------=_NextPart_000_0551_01C37D3B.46A05140 Content-Type: text/html; charset="koi8-r" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3D"text/html; charset=3Dkoi8-r" http-equiv=3DContent-Type> <META content=3D"MSHTML 5.00.3700.6699" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3D"Arial Cyr" size=3D2>Hi.</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3D"Arial Cyr" size=3D2>How I can receive the following = result=20 from</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3D"Arial Cyr" size=3D2>select '>' || fixfld || '<' = from=20 table</FONT></DIV> <DIV><FONT face=3D"Arial Cyr" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Arial Cyr" size=3D2>>8<</FONT></DIV> <DIV><FONT face=3D"Arial Cyr" size=3D2></FONT> </DIV> <DIV><FONT face=3D"Arial Cyr" size=3D2>Where fixfld =3D 8 for example = and <FONT=20 face=3D"Arial Cyr" size=3D2>fixfld is fixed (5,2)</FONT>.</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3D"Arial Cyr" size=3D2>I receive = >8.00<</FONT></DIV> <DIV> </DIV></BODY></HTML> ------=_NextPart_000_0551_01C37D3B.46A05140--