>Hi All:
>
>Do you have an easy way for testing if a character field contains valid numeric data.
>
>Someone suggested:
>
>
>IF TRANSFORM(VAL(m.luValue)) == m.luValue
>
>
>but this doesn't work every time. e.g. when luValue = '08'
>
>Thanks,
>
>Yossi
Type(myTable.MyField) = 'N'
If it's not broken, fix it until it is.
My Blog