Remove Wildcard

[geoffcodd]

I have a table which contains the following info

Invoice_Number
*1005016023-012
*2006139784-010
*2006139861-010
1005986795-065
*1005017101-51
1005017112-046
1005017266-047
*1005017354-048
*1005017508-050
*1005518327-047

I need to remove the * from all records containing it the problem I am having is that * is the wildcard character

Any ideas appreciated

Thanks
Geoff

 

[Mile-O]

If the * is always the first character then this expression should remove the asterisk.

NewField: IIf(Left([MyField],1) = "*", Mid([MyField], 2), [MyField])

 

[geoffcodd]

Thank you, you are a star