Sql and Database

[tufanocak]

i am trying to add my data on the right of the Access/or AS400 database cell ,is it posible with a special JET-SQL command.

strSQL = "INSERT into HASTA.KULARAPF(ASIPTES,AKULKD,AKULHS,AKULSR,ASIRAD,AKULAD,AKULSOY,AHASAD,AURNAD,AURNKD,ASIPNO,ASIPTA R,ONAYTAR,ONAYDUR,ASIPVADE,ASIPADR,ASIPACIK,ASIPISKO,AMIKTAR,AKULKO3,AFIYTL,AFIYLS,AKULKO1,AKULKO2,H ASAD41) values('"&teslimtarih&"','"&KULKOD&"','"&MKULHS&"',"&KULMUS&",'"&KULSIR&"',
'"&KULADI&"','"&KULSOY&"','"&MKULAD&"','"&urnadi&"','"&urnkod&"',"&SIPNO&",
'"&tarih&"','"&onaytarih&"','"&onaydur&"','"&asipvade&"','"&adreskodu&"',
'"&aciklama&"',000.00,"&URNMIKTAR&",'"&akulko3&"',000000000000.000,00000,'"&akulko1&"',
'"&akulko2&"','"&adresdort&"')"

Normal it writes on a Char(8) cell :5894_______

but i want that it writes on the right :_______5894

Can anybody help?

[whammy]

In AS/400, from what I gather, you need to add leading zeroes. However, here's a REALLY easy way to do it (assuming you have a 10 character field):

mystring = Right("0000000000" & mystring,10)

Hope this helps.

[tufanocak]

it works now in AS/400 database, Thanks.

[whammy]

:cool: