I have some data that looks like this:
C:10
R:200
N/A
E:3
N/A
N:77
I'm trying to remove the first two characters for each row, and skip the rows with N/A
I've been trying to figure out how to do this with SUBSTRING
but have had no luck.
UPDATE d1
SET d1_val = SUBSTRING(d1_val, 1, LENGTH(d1_val)2)
Try
UPDATE d1
SET d1_val = SUBSTRING(d1_val, 3)
WHERE d1_val <> 'N/A'
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With