Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a long and always changing list of Order Numbers, (example : ORD 0017906713)
I need to replace the space and put '-' instead. I'm currently struggling as the replace function will ask me to put a specific term to substitute with a new one.
I hope that makes sense (ps: excuse my poor english)
Thank you in advance,
Michela
replace([Order Numbers],' ','-') as Whatever