Nadya,

Here's one more idea: ISDIGIT(). You would need to parse the string one character at a time. Also, if you encountered a "/" or "-" you could check that the rest of the format was an appropriate date.


>Hi everyone,
>
>We have a Global Editor form, which allows to globally modify field's contents. The form itself is quite simple, it has combobox with fields and textbox to enter a value to replace with. Now, suppose I choose Numeric field and type 11 in this textbox. How can I check, that this entered value is Numeric and replace my field with this?
>Same question for date, datetime, and logical fields as well...
>
>Thanks in advance.