UFN_WORKSTATION_GETIDBYMACHINENAME

create function dbo.UFN_WORKSTATION_GETIDBYMACHINENAME(@WORKSTATIONMACHINENAME nvarchar(255))
returns uniqueidentifier
as begin
    return (
        select top 1 ID 
        from dbo.WORKSTATION 
        where (@WORKSTATIONMACHINENAME = MACHINENAME) 
            or 
            (@WORKSTATIONMACHINENAME = 
                (
                    case when charindex('.', MACHINENAME) > 1
                    then left(MACHINENAME, charindex('.', MACHINENAME) -1)
                    end
                )
            )
    );
end