Skip to content
Advertisement

Tag: data-cleaning

Omit certain characters from Rows in SQL

I have a column that has Serial Numbers but some of them has unwanted characters attached with the Serial Number:- These are some of the entries from a Column in a SQL Table. I want to omit all the characters including and after the Underscore. For example, these values would become this:- 8558088363_AAC = 8558088363 7272505721_R2C = 7272505721 And keep

Advertisement