Remove numbers in middle of field ?

[jkpats12]

Hello,

Is it possible to remove a couple of numbers in the middle of a field by using an update query ?

I have for example: YF000491 and would like to make it YF0491.

Any help would be greatly appreciated.

Thanks

 

[KeithG]

Yes it is possible with the Right,Left, and/or Mid functions.

 

[jkpats12]

Thansk for the reponse Keith, but I'm not too familiar on creating those....would anyone happen to have an example ?

Thanks

 

[jkpats12]

That is correct Bob

 

[jkpats12]

Bob thank you very much this worked perfectly.

 

[sharzi]

Can someone tell me if we have some condition that we don't want to apply left or right to those conditions then what we should do?

 

[arnelgp]

if the condition is simple. you can use sing Left, Right, Mid.
if more complex that the query cannot evaluate it, use Function.

 

[sharzi]

if the condition is simple. you can use sing Left, Right, Mid.
if more complex that the query cannot evaluate it, use Function.

How to use function?