Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help on a function

Status
Not open for further replies.

bugzLue

IS-IT--Management
Feb 27, 2001
57
US
I am looking to find out what the 0x0000FFFF means, any help would be great Thanks

RETURN ( cast( ((@jctID / power(cast(2 as bigint),32)) & 0x0000FFFF ) AS INT));
END Live to learn or die trying
 


Dear ;

I think it is hexadecimal no. and you can see it to cast it as integer.

Select cast(0x0000FFFF as int) as DecimalNumber

It will give you 65535. So , I think it is that.

Regards,
Muhammad Essa Mughal
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top