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