hello
i need to modify some cells in a sql table
i had cells like this in a colum called description:
10000259 - 10000259 - CATHETER SUCTION 10 FR, WITH FINGER TIP CONTROL DISPOSABLE, STERILE
10000304 - 10000304 - CLIP, HEAMOSTATIC, MEDIUM , TITANIUM, WHITE, SINGLE USE, STERILE
i neeed to delete only the numbers:
CATHETER SUCTION 10 FR, WITH FINGER TIP CONTROL DISPOSABLE, STERILE
CLIP, HEAMOSTATIC, MEDIUM , TITANIUM, WHITE, SINGLE USE, STERILE
i need a funtion becouse i have to modify around 2000, all the numbers in this cells i need to delete had 8 digits.
can someone help me with this
thanks in advance
What I have tried:
update table
set description = 'CATHETER SUCTION 10 FR, WITH FINGER TIP CONTROL ' where description = '10000259 - 10000259 - CATHETER SUCTION 10 FR, WITH FINGER TIP CONTROL '