Extract number out of character column and use it to update another column Simon Hutchinson

​[[{“value”:”A friend told me about the old database he had to work with. There was one file with a field that contained two pieces of information. Any leading characters, A – Z, meant one thing and the numbers within it meant something else. Unfortunately there could be any number of leading characters, the numbers could be three of four long, and there could be characters at the end. The examples he shared with me were:


His plan was to add a new numeric field to the file, and update it with the numbers extracted from this original field.
“What would be a simple way to do this with SQL?” he asked.
Read more »”}]] Read More 

Verified by MonsterInsights