Sample Header Ad - 728x90

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