Update in access

[Lasse Edsvik]

Hello

I have a table with about 900 rows and i would like to update them all......

all have a prefix infront of them followed by a _ and i want to remove that
and all infront of it......

e.g


AB_test
CCC_test2
XX_test3
XD_test4
AB_adff


should be:

test
test2
test3
test4
adff

there are about 30 different ones so i dont wanna do that manually for each
one :(

TIA
/Lasse

[Bob Barrows]

Lasse Edsvik wrote:

> Hello
>
> I have a table with about 900 rows and i would like to update them
> all......
>
> all have a prefix infront of them followed by a _ and i want to
> remove that and all infront of it......
>
> e.g
>
>
> AB_test
> CCC_test2
> XX_test3
> XD_test4
> AB_adff
>
>
> should be:
>
> test
> test2
> test3
> test4
> adff
>
> there are about 30 different ones so i dont wanna do that manually
> for each one :(
>
> TIA
> /Lasse

UPDATE tablename
SET fieldname = Mid(fieldname,Instr(fieldname,"_")+1)

HTH,
Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.