format number in field

[sal21]

I just have a jet ado conn opned.
my db is access
my table is named Mytable
Into field CODE have a value similar:

0500-1
6875-45
...

How to update, with a sql query to format the right item from "-" in #000000 for all value in column field.
and have a result similar

0500-000001
6875-000045
...

[Jezza]

Hi Sal

Does this string manipulation function help you:

Left(Code,InStr(Code,"-")) & Format(Right(Code,Len(Code)-InStr(Code,"-")),"000000")

[sal21]

Hi Sal

Does this string manipulation function help you:

Left(Code,InStr(Code,"-")) & Format(Right(Code,Len(Code)-InStr(Code,"-")),"000000")

hi friend but i need the sql command

similar sql="....."

[silverback]

Sorry - forgot to credit Jezza with the superb code in my earlier posting.
Silverback
=================================================================

I tried this and it worked OK for me.

UPDATE MyTable SET MyTable.Code = Left(

Code: Select all

,InStr([Code],"-")) & Format(Right([Code],Len([Code])-InStr([Code],"-")),"000000");

Hope this helps
Silverback

[sal21]

I tried this and it worked OK for me.

UPDATE MyTable SET MyTable.Code = Left(

Code: Select all

,InStr([Code],"-")) & Format(Right([Code],Len([Code])-InStr([Code],"-")),"000000");

Hope this helps
Silverback[/quote]

Perfect! Tks.
Sal.