I know I am going to have to create a UDF for this, but I'll ask the
question first.

I have a data source which has 'age' as a field. This is normally years,
but also includes some text (3 mths, infant, 2 d, etc) There are not
many text entries, and a lot I've filtered, but I need a check ideally
in the CASE statement that pulls out the 'clean' numeric year entries,
so I'm just left with the odd ones.

Anybody covered this one already, or do I borrow the PHP code. I'm
tempted to just run a PHP script to tidy it up, but I've 30,000 records
so far, and only have some 'C' records, the whole database will be quite
large, and needs checking as new blocks are added.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services