var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL get first character of a string
Is there a function in SQL that will find the first character of a character string?
Select Org from PR where id = '100'
Normally, Org will retuen a string such as '1:00'. But, all I want from this string is the first character, '1'.
I figured it out.
SUBSTRING(Org, 1, LEN(Org) - 3)
A simpler way is LEFT(Org,1)
So you want to return the same value when Org = '1:00' as when Org = '10:00', '11:00', or '12:00'?
I hope these aren't time values you are dealing with...