Update Query

[elgoober]

Hi

I want to remove the last 2 characters in a code - so in the stock code

BS1222222ZZ

I want to get rid of the ZZ.

There are 6000 records that need to be amended.

I was thinking about some form of query that would

a) Count the number of charcters (Expr1)
b) Based on the number of characters perform an extract (say IIf say no of chars in Expr1 = 7, mid(Expr1,1,5) else blah

Then update b) to the original sequence.

Is this sensible - or is there a more informed method.

Cheers

Paul

 

[Bilbo_Baggins_Esq]

Expr2:left(Expr1,len(Expr1)-2)

 

[elgoober]

Perfect

Thanks Bilbo.