>>>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
I see Tamar has already given you something which should work.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up