Guys..

Instead this will work to get the active node name on the cluster as well..!

select CONVERT(VARCHAR(10), SERVERPROPERTY('ComputerNamePhysicalNetBIOS'))

-VS

"there are 10 types of people in the world...those who understand binary and those who don't..."