Stripping unwanted data from fields

Giganews Newsgroups
Subject: Stripping unwanted data from fields
Posted by:  Robin (robin.harris…@vodafone.co.uk)
Date: Tue, 7 Oct 2003

Hi,

does anyone know a way to remove data of a certain type
from a field.
To explain further i'm importing numbers from a db
(access) which have a letter appended to the end e.g.
4821B.

I need to remove the 'B' (the letter at the end) so that
all i'm left with is a numeral.

Hope this is clear enough.

Robin

Replies