getting rid of -

  • Thread starter Thread starter Turi
  • Start date Start date
T

Turi

I have a table with a bunch of product codes (380-tt, 81-
tt, 1-f-tt, etc.). I want to get rid of all the "-"s in
the product code. How do I write a query to do this, I
know I've done it before, but I can't remember what I did.

Thanks
 
I have a table with a bunch of product codes (380-tt, 81-
tt, 1-f-tt, etc.). I want to get rid of all the "-"s in
the product code. How do I write a query to do this, I
know I've done it before, but I can't remember what I did.

Thanks
Click to expand...

If you are using Access 2000 or newer you could use the Replace()
function:
Exp:Replace([FieldName],"-","")

If you are using Access 97 or older you will need to write your own
User Defined function. Post back if you need help with that.
 
Back
Top