Subject | Substring? |
---|---|
Author | Joe Martinez |
Post date | 2001-08-17T17:24:52Z |
I'm trying to remove the first 3 characters characters from the
beginning of a VARCHAR string for a set of records.
something like:
update mytable
set myfield = [myfield, minus the first 3 characters]
where...
How would I do that?
I won't know how many total characters are in the string (it varies, but
always at least 4). All I know is that I need to remove the first 3.
Thanks,
Joe
beginning of a VARCHAR string for a set of records.
something like:
update mytable
set myfield = [myfield, minus the first 3 characters]
where...
How would I do that?
I won't know how many total characters are in the string (it varies, but
always at least 4). All I know is that I need to remove the first 3.
Thanks,
Joe