thanks. On 7/19/06, Phillip Holmes <[EMAIL PROTECTED]> wrote: > > Actually, you can get rid of the @temp var, or not. > > DECLARE > @myOctect varchar(32), > @i int, > @power int, > @result int > > SET @myOctect = '00000101' > SET @power = len(@myoctect) - 1 > SET @i = @power + 1 > SET @result = 0 > WHILE @i >= 1 > BEGIN > SET @result = @result + substring(reverse(@myOctect),@i,1) * > Power(2,@power) > SET @i = @i - 1 > SET @power = @power - 1 > END > > SELECT @result > > > Warmest Regards, > > Phillip B. Holmes > http://phillipholmes.com > 214-995-6175 (cell) > > -- > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.1.394 / Virus Database: 268.10.1/390 - Release Date: 7/17/2006 > > > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/cf_lists/message.cfm/forumid:6/messageid:2515 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
