Explanation needed for my result
0
votes
1
answer
74
views
I am new to string handling in SQL server and was wondering what makes the below code return the result it returns. Could I please have a detailed explanation?
**My code:**
Select CAST(CAST(CAST('08' as nvarchar) as varbinary) as varchar) as [result]
**Output:**
>| Result |\
| 0 |
What is happening here from '08' being converted to nvarchar to varbinary to varchar??
Asked by varun as
(11 rep)
Sep 21, 2024, 11:45 AM
Last activity: Sep 28, 2024, 04:58 AM
Last activity: Sep 28, 2024, 04:58 AM