Subject select where field contains non-ascii characters
Author Erik LaBianca
Hello All,



Apologies if this has been covered before, google isn't getting me very
far.



I'd like to be able to select rows in firebird 1.5.3 that contain
non-ascii characters. Something like select * from table where not
isalnum(field). Is there an elegant way to do this without resorting to
writing and deploying a custom UDF? If I need a UDF, is there a library
already out there with a suitable function in it? I'm not seeing
anything that looks like it could do it in fbudf or ib_udf.



Thanks



--erik





[Non-text portions of this message have been removed]