Hi,
substr() doesn't exist in MySQL.
Use substring().
UPDATE DocComms SET ItemHSCode = concat(substring( ItemHSCode, 1, 4 ),
substring( ItemHSCode, 6, 2 ), substring( ItemHSCode, 9, 2 ))
On Tue, 2003-01-21 at 15:34, Don wrote:
> Hi,
> RESENT DFUE TO TYPO
>
> I want to change a field in a tab
* Don
> I want to change a field in a table. Currently the data is in
> theformat -->
> 4818.50.00
> I want to remove the decimal points so that it is like --> 48185000
> I tried the sql code below but am getting a syntax error. Can someone
> please point out the error of my ways?
>
> UPDATE DocC
Hi,
RESENT DFUE TO TYPO
I want to change a field in a table. Currently the data is in theformat -->
4818.50.00
I want to remove the decimal points so that it is like --> 48185000
I tried the sql code below but am getting a syntax error. Can someone
please point out the error of my ways?
UPDATE
Hi,
I want to change a field in a table. Currently the data is in the
format --> 4818.50.00
I want to remove the decimal points so that it is like --> 4818.50.00
I tried the sql code below but am getting a syntax error. Can someone
please
point out the error of my ways?
UPDATE DocComms SET Item