I use Access 97 (German Version) -
- I open a form to enter a part number into a local table
- 'on update' of the part number field I start cross
checking to see if the new part number exists already
in a remote master table (linked via ODBC)
- cross checking is done in a
Public...
Hello,
I have a 8-digit hex number given as a character column
in my database running under SQL Server 7.0 (not 2000).
I want to convert it into a binary variable in order
to increment it.
I did not succeed with the following statements:
-- Test binary conversion,
-- Vers. 2.x for T-SQL...
Hello,
I want to increment a hex number by 8 (given as String in @strVar1).
Casting hex numbers seems impossible to mee, since I did not succeed with the following statements:
set @strVar1 = '3b24a3b81c'
set @binVar1 = cast ('0x' + @strVar1 as binary)
set @IntVar1 = cast (@binVar1 as...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.