Re: Trimming data in a d=field

Kirsten wrote:

> I have a group of data in a particular field that has 2 digits at the
> beginning that I would like to remove. These two digits only appear on
> some of the data in that field though.
> Specifically, in my company name field, I have some data that got
> imported as
> "% company name". I need to get rid of the percentage sign and space
> at the beginning of some of these company names.
> Can somebody please tell me what my SQL statement would be??
> Thanks.

UPDATE mytable
SET myfield = SUBSTR(myfield,3)
WHERE SUBSTR(myfield1,2) = '% ';

And I'm not testing this so I'm assumign the % sign causes no problems.

Daniel Morgan Received on Thu May 16 2002 - 18:20:13 CDT