How to get rid of the - symbols in edit query mode

[Anonymous]

Hi

I need to format in "Edit query" mode this:

into same results but without the "-". 

It has to be now 20200621 etc.

[Anonymous]

You will find the solution here

Do explore the community thoroughly before posting to see if others had asked similar question before. Kindly mark this post as solution if it helped. 

[jdbuchanan71 · Accepted solution]

If you right click on the column you should be able to replace "-" with null and that will strip them out.