Hi
I m using a update query to delete everything in a column which is after the last "-". the code is as below
The trouble I m having is that some of the fields don't have any "-" in them and so it deletes the whole entry which is not what I m looking for
UPDATE [PRODUCTREGISTER SCP] SET [PRODUCTREGISTER SCP].Manufacturer_Part_Number = Left([PRODUCTREGISTER SCP].[Manufacturer_Part_Number],InStr([manufacturer_part_number],"-")-1)
Can anyone help with this?
Ali
I m using a update query to delete everything in a column which is after the last "-". the code is as below
The trouble I m having is that some of the fields don't have any "-" in them and so it deletes the whole entry which is not what I m looking for
UPDATE [PRODUCTREGISTER SCP] SET [PRODUCTREGISTER SCP].Manufacturer_Part_Number = Left([PRODUCTREGISTER SCP].[Manufacturer_Part_Number],InStr([manufacturer_part_number],"-")-1)
Can anyone help with this?
Ali