Re: Remove first character
- From: "Amy Blankenship" <Amy_nospam@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 6 Jul 2007 11:15:49 -0500
"neenmarie" <neenmarie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C1D0C687-255C-4044-9C04-E6CAE0251444@xxxxxxxxxxxxxxxx
I need to remove an apostrophe from the beginning of each entry in a field.
The entries vary, ie:
'6788993
'103-5597
'P103
UPDATE MyTable SET MyField = Right(MyField, Len(MyField) - 1);
Or
UPDATE MyTable SET MyField = Replace(MyField, "'", "");
.
- Follow-Ups:
- Re: Remove first character
- From: Ken Snell \(MVP\)
- Re: Remove first character
- Prev by Date: RE: Display fields Limited on Values
- Next by Date: Re: SQL Syntax Error
- Previous by thread: adding new records from one table to an existing table
- Next by thread: Re: Remove first character
- Index(es):
Loading
