UPDATE sales ;
set idnum = 'A001'+right(idnum,4)
is a pure SQL update statement. What're you looking for?
>Thanks Cetin but I really need a pure SQL for the string replacement.
>
>Regards
>Doug Johnston
>
>
>>>Hi,
>>>
>>>I have a Paradox sales.db file accessed via ODBC where I need to change all the first 4 characters of the sales.idnum which is a PK field. I would rather use SQL as in the past this has proved faster than loading a remote view, doing a string replacement and updating the view.
>>>
>>>The scenario is as below...
>>>
>>>Original sales.idnum
>>>S0991231
>>>S0991232
>>>S0991233
>>>S0991234
>>>
>>>Need to be changed to...
>>>A0011231
>>>A0011232
>>>A0011233
>>>A0011234
>>>
>>>I guess what I am looking for is an SQL equivelant to...
>>>UPDATE ALL sales.idnum WITH 'A001'+SUBSTR(sales.idnum,5,4)
>>>
>>>Regards
>>>Doug Johnston
>>
>>Doug,
>>Substr() might exists in paradox driver as is or as 'substring', stuff as is or as 'replace' ( it has been long not Paradoxed :)
>>If you could base it on right() then it's almost supported with all.
>>
>>
UPDATE sales ;
>> set idnum = 'A001'+right(idnum,4)
Cetin
--sb--