The field var2 in my table has this value: " 89 5426 "
var2
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