var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Strip 0
I have a table with some data in it. This colume holds project numbers that have some 0 at the beginning, I would like to strip the 0 off during the select how can I do this?
For Example 00000390 should look like 390 when it's returned.
This will work as long as all your project numbers are numeric:
select cast(cast('00000390' as int) as varchar(8))
That worked !!!
Thanks for all your help!