>Hi everybody,
>
>We have a phone field, which can contain phone, can be empty or can contain words "Do not call". However, these words could be changed. My original SQL was not inlist(PHONE, space(12),'Do not call'). Obviously, this would not work, if these words are going to change. So, I need to check, if I have at least one digit in a PHONE field. I'm thinking, what would be the best way of doing it in SQL. We don't have index on PHONE field, so it probably not that important...
>
>Thanks a lot in advance.
ISDIGIT(PHONE) should work in this case assuming that only valid phone # can start with digit.
--sb--