SQL Not Numeric

[PWD]

Good morning, I apologise if this isn't the correct forum but "out there" I can't seem to find a sensible answer. I have been given an application that uses Oracle SQL and all I want to do is to select records where the LastName field is neither empty, nor "." nor numeric. I can do

is not null[indent][/indent]<> '.'

But can't see that there's an "ISNUMERIC" or something similar. This is just a test environment so I'm not looking to forensically clean that field - just trying play around with the data.

Many thanks,
D€$

 

[PWD]

Oh, of course!!!

and trim(translate(PN.LAST_NAME,'0123456789',' ')) is not null

Many thanks,
D€$

 

[djj55]

There is always

PATINDEX('%[^0-9]%', PN.Last_Name) > 0

djj
The Lord is my shepherd (Psalm 23) - I need someone to lead me!