declare @param as varchar(max)
declare @Pattern as varchar(max)
set @param='1001-COAKPL-DL_VSP-FC_RU2-HYDRC-1001'
set @Pattern = '%' +SUBSTRING( @param,1,4) + '%'
SELECT ROW_NUMBER() OVER (ORDER BY RouteId) AS [S.No.],RouteId,RouteSummary FROM Ops_Route_Master WHERE RouteSummary LIKE @Pattern;