bank sort code issue

[Lapchien]

One of my fields for bank sort codes currently has lots of 33-33-33 type
numbers, and I want to be able to remove the - and have just 333333. Is
there a quick bit of code that will look through the 'sortcode' field in the
'Service Agreements' Table and remove '-'?

Thanks,
Lap

[Lyle Fairfield]

Re: bank sort code issue

"Lapchien" <nosp@m.com> wrote in
news:1071065877 .560640@ananke. eclipse.net.uk:
[color=blue]
> One of my fields for bank sort codes currently has lots of 33-33-33 type
> numbers, and I want to be able to remove the - and have just 333333. Is
> there a quick bit of code that will look through the 'sortcode' field in
> the 'Service Agreements' Table and remove '-'?
>
> Thanks,
> Lap[/color]

The Replace Function?


--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[Lapchien]

Re: bank sort code issue

Of course DOH! sorry for not spotting the blindingly obvious!


"Lyle Fairfield" <MissingAddress @Invalid.Com> wrote in message
news:Xns944D625 EC1311FFDBA@130 .133.1.4...[color=blue]
> "Lapchien" <nosp@m.com> wrote in
> news:1071065877 .560640@ananke. eclipse.net.uk:
>[color=green]
> > One of my fields for bank sort codes currently has lots of 33-33-33 type
> > numbers, and I want to be able to remove the - and have just 333333. Is
> > there a quick bit of code that will look through the 'sortcode' field in
> > the 'Service Agreements' Table and remove '-'?
> >
> > Thanks,
> > Lap[/color]
>
> The Replace Function?
>
>
> --
> Lyle
> (for e-mail refer to http://ffdba.com/contacts.htm)[/color]