SQL - Filter for values without alphanumeric characters

Hello!

I would like to execute following sql statement:

SELECT MAX(Column1) FROM Table1

and assign the result to an integer variable.

The conversion will fail, if the maximum contains alphanumeric characters.

Is there a possibility to set a WHERE clause to filter only those values not having alphanumeric characters?

Regards,
Robert Received on Wed Jun 28 2006 - 07:45:32 CDT