How to Insert '0' at the Left Most of the field ??

dick Won

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

How to Insert '0' at the Left Most of the field ??

Hello,

I have a question on how to Insert '0' at the left hand side of the
field , just like the PADL function. example : the field called 'SO_no' and
the type is Integer.
If I want the field has a record '0003' and next record is '0004' etc.
How can I insert the '0' at the left most in the MS SQL server ????

Thanks for your help and attention.

Regard,
dick Wong

Laurent ANTOIN

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:How to Insert '0' at the Left Most of the field ??

Put '000000000' into the DisplayFormat

Laurent

Quote

dick Wong wrote in message <01bd7899$156e4700$0b31a1ce@dick_Wong>...
>Hello,

> I have a question on how to Insert '0' at the left hand side of the
>field , just like the PADL function. example : the field called 'SO_no' and
>the type is Integer.
>If I want the field has a record '0003' and next record is '0004' etc.
>How can I insert the '0' at the left most in the MS SQL server ????

>Thanks for your help and attention.

>Regard,
> {*word*106} Wong

Jim Elde

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:How to Insert '0' at the Left Most of the field ??

Provided that the receiving field is a character datatype, you can do

FieldByName('your_field').AsString := Format('%4.4d', [your_integer]);

Jim

Quote

dick Wong wrote:
> Hello,

> I have a question on how to Insert '0' at the left hand side of the
> field , just like the PADL function. example : the field called 'SO_no' and
> the type is Integer.
> If I want the field has a record '0003' and next record is '0004' etc.
> How can I insert the '0' at the left most in the MS SQL server ????

> Thanks for your help and attention.

> Regard,
> dick Wong

Other Threads

1. inserting record with 'insert'

2. Using function like SQL-Server's Left (field,5) in dbas

3. type field ''money''

4. Field 'FIELD' Required

5. DBGrid1.Fields[0] - Where's The Value During Insert/Before Post

6. Key Violation occurs before 'Before Insert'

7. Exception after 'Insert' with TUpdateSQL

8. tstrings property's write method doesn't get called on insert

9. Memo--'Insert' key no work

10. Can insert a tabsheet from DLL but now can't insert content into tabsheet