Strip field of numeric digits 2

[Flippertje]

Hello all,

i'm trying to strip a field of its numbers.
My table contains fields like
TV1
TV2
TV3
TV
TV200
IPOD12

In a query i'm tying to lose the numbers so that only text remains.

Anyone?

Many thanks!

Scoobs

 

[PHV]

You may create an UDF (User Defined Function) written in VBA.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Swi]

Here is a good example:

http://www.pacificdb.com.au/MVP/Code/StripChars.htm

Swi