>>I have a database that has following character string values:
>>
>>
>>"3440.01"
>>"3440.02"
>>...
>>...
>>"3440.99"
>>"3440.100"
>>"3440.101"
>>"3440.102"
>>"3440.103"
>>
>>
>>
>>how can I write a sql update statement that will change all the range values from "3440.01" to "3440.99" to new values of "4567.01" to "4567.99". And then the remaining range of values "3440.100" to "3440.103" to new range of values as "4569.100" to "4569.103"
>
>Is it a VFP table, or a SQL backend?
hi Al
vfp 8.0 sp1
nick