| Author |
 Topic  |
|
|
sql_newb2043
Starting Member
2 Posts |
 Posted - 04/24/2012 : 03:15:20
|
I am getting this error, the data type varchar and varchar are incompatible in the boolean XOR operator, what am I doing wrong? Below is my query. i am actually doing XOR on two strings. Is this format is correct?
firstly I updated the password, converted in hex and save it.
UPDATE tbl_user SET password = SubString(master.dbo.fn_varbintohexstr(HashBytes('MD5', 'admin123')), 3, 32) WHERE login_id = 'user123'
The above is working fine, but below is not working fine, giving the error "the data type varchar and varchar are incompatible in the boolean XOR operator".
DECLARE @var1 varchar(42), @var2 varchar(32), @var3 varchar(32)
SET @var1 = 'The universe is made of stories not atoms.'
SELECT @var2 = password FROM tbl_user WHERE login_id = 'user123'
SET @var3 = CONVERT(varchar(42), @var1) ^ CONVERT(varchar(32), @var2)
SELECT @var3 |
|
|
Lumbago
Norsk Yak Master
Norway
3241 Posts |
|
|
sql_newb2043
Starting Member
2 Posts |
Posted - 04/24/2012 : 04:03:05
|
what I have done now
DECLARE @var1 varchar(42), @var2 varchar(32), @var3 varchar(32)
SET @var1 = 'The universe is made of stories not atoms.'
SELECT @var2 = password
FROM emp_user
WHERE login_id = 'mobile'
SET @var3 = CAST(@var1 AS INT) ^ CAST(@var2 AS INT)
SELECT @var3
now it is giving an error Conversion failed when converting the varchar value '' to data type int |
 |
|
|
Lumbago
Norsk Yak Master
Norway
3241 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47037 Posts |
Posted - 04/24/2012 : 21:51:58
|
quote:
Originally posted by sql_newb2043
what I have done now
DECLARE @var1 varchar(42), @var2 varchar(32), @var3 varchar(32)
SET @var1 = 'The universe is made of stories not atoms.'
SELECT @var2 = password
FROM emp_user
WHERE login_id = 'mobile'
SET @var3 = CAST(@var1 AS INT) ^ CAST(@var2 AS INT)
SELECT @var3
now it is giving an error Conversion failed when converting the varchar value '' to data type int
what is the int value you need to convert '' to?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
| |
Topic |
|
the data type varchar and varchar are incompatible
