vendredi 10 avril 2015

replace doesn't replace all whitespace

The field var2 in my table has this value: " 89 5426 "


When running this query:



SELECT replace(var2,' ','A') as var2 WHERE .....


the result is "AA89 5426AA".


Why is the middle whitespace not replaced?


Aucun commentaire:

Enregistrer un commentaire