Hello Everyone,
I want to sort few records which actually contains Duration but they are in nvarchar datatype.. For eg.
Select '33:14:14' as 'Duration'
UNION
Select '1:16:36' as 'Duration'
UNION
Select '0:3' as 'Duration'
UNION
Select '0:29' as 'Duration'
UNION
Select '02:12:39' as 'Duration'
I want to sort them.. Unfortunately I am getting results in above format (like 0:3 which is wrong practice) but still is there any way to do so ?
Thanks,