that is a way I have tried it and it does seem to locate the special characters. however I am trying to use this statement as one of the conditions that has to be meet in a where statement. my code looks like this;
where A>1 or len(purgechar(fieldname, 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890'))>0;
I see your point and I have done it that way.
however I require to do this test for several fields in the same table, so I was hoping I didnt have to create new names for all of them. One thing I forgot to mention, the way I have done it above works with most fields and is only failing on 1 field.
I will resort to your method if I fail to find a way around the problem though.
I am using
to flag an error if there are anything apart from letters or numbers in the field.
However, if I set the above expression >0 it flags all the fields as an error. If I set it >1 it miss out on fields that ONLY contain special characters.
Does anyone know what I am doing wrong? Has anyone had this error before?