>
>UPDATE Client SET Field1=VAL(Field2)
>WHERE ISNUMERIC(Field + 'e1') = 1
>
>
>That "Field + 'e1'" is just for SKIP all these records where you have '1e7' or '234d2' values.
Exactly, as this is what I just found out. Based on a conference call today, we thought it was only digits but on some records we have characters. So, we have to consider that and it ended up that we will avoid that approach. :)