var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have a field in SQL Server table that somehow got data altered. So the data reads like this Test ,Test Is there a way for me to run an update query which will modify the data back to the original formatting of Test, Test?
Last edited by IndigoMontoya; 12-21-12 at 17:26.
set mycolumn = replace(mycolumn, ' ,', ',')
This will replace ' ,' with just a single comma. And of course mytable = your table name and mycolumn = your field name.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors