- see footer for list info -<
Hi All,
Was wondering if anyone had any handy knowledge of how I might convert a binary string to an int in mssql. For example I have: 0x713 which would translate to: 000001*1*100010011 (not worried about padding right now ;) ) I have a cf function that does this, but I need to query an mssql table to find out if a flag is set - running 4+ million data rows through cf to find out if the flag is set is not ideal - thankfully I only need to do this on a months worth of data. Any help is appreciated - I'm sick of google ;) TIA, Tom _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:-
- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< - Lists hosted by www.Gradwell.com -< - CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
