var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: return text to chosen character
how can i return text in a column up until a special character?
I have this:
And i want this:
How can i return everthing thats left (or right) of the '_' character? i have tried use LEFT/RIGHT and SUBSTRING but i just cant make it to work.
thx in advance //Mr
You need the CHARINDEX() function.
works like a charm... thx alot.