Replace

Declare

@MAC as Varchar(250)

Set

@Mac=

begin

if (@__filterwildcard = ) SELECT DISTINCT dbo.v_GS_NETWORK_ADAPTER.MACAddress0 FROM dbo.v_R_System INNER JOIN dbo.v_GS_NETWORK_ADAPTER ON dbo.v_R_System.ResourceID = dbo.v_GS_NETWORK_ADAPTER.ResourceID WHERE dbo.v_R_System.Client0 = 1 else begin set @mac= REPLACE(@__filterwildcard,‘-‘,‘:’) — Added by me SELECT DISTINCT dbo.v_GS_NETWORK_ADAPTER.MACAddress0 from dbo.v_R_System INNER JOIN dbo.v_GS_NETWORK_ADAPTER ON dbo.v_R_System.ResourceID = dbo.v_GS_NETWORK_ADAPTER.ResourceID and dbo.v_GS_NETWORK_ADAPTER.MACAddress0 like @Mac WHERE dbo.v_R_System.Client0 = 1 and dbo.v_GS_NETWORK_ADAPTER.MACAddress0 like @Mac ORDER By dbo.v_GS_NETWORK_ADAPTER.MACAddress0 end

end

Leave a Reply

Your email address will not be published. Required fields are marked *