var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Unwanted Character Space in field
I have a column in a database the most of the records have a space before the first character in a text field.
Is it possible to do a update query of sorts to go through the records and delete the first space if any ?
You can do a ltrim in your update statement. So update table set field = ltrim(field). Do you want to delete all leading spaces or just 1 ?
don't forget to add a WHERE clause, so that you update only those rows that meet the condition