Find all Alphanumeric Characters

[hilbertl3]

I am trying to identify whether or not there are any
alphanumeric characters in a field. Is there a way to do this using expressions?

hilbert l

 

[SantaMufasa]

Hilbert,

Yes, we can certainly help in this regard. Here are some questions for which your answers will help us design a satisfying solution for you:

1) What do you want the results of a function to be if its argument contains one or more alphanumeric characters?

2) What do you want the results of a function to be if its argument does not contain one or more alphanumeric characters?

3) How would you characterise an alphanumeric character?

4) What characters are not alphanumeric insofar as this application is concerned?

Looking forward to your responses.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]