Here's the cleaned up sample data for anyone looking to work on the function:CREATE TABLE #T2 (
     varchar(1000)
);
INSERT INTO #T2 ()
VALUES    ('https://www.abc123.com/search?breadcrumbs%5B0%5D=red-big-widget&breadcrumbs%5B1%5D=red-long-big-widgets&cc=LUNERATOOBS&facet.multiselect=true&page=1&q=*&rows=15&son=0&sort=price+asc&start=0&filter=(category:"12897")&filter=(a_brand_t_fq:"BrandLoonry")&filter=(a_length_d_fq:[12%20TO%2024]%20OR%20a_length_d_fq:[24%20TO%2036]%20OR%20a_length_d_fq:[36%20TO%2048])&filter=(a_dimmable_t_fq:"Yes")'),
        ('https://www.abc123.com/search?facet.multiselect=true&page=1&q=*&rows=15&son=0&sort=price+asc&start=0&filter=(category:"12897")&filter=(a_brand_t_fq:"Euro%20Litny")&filter=(a_voltage_t_fq:"120")'),
        ('https://www.abc123.com/search?facet.multiselect=true&page=1&q=*&rows=15&son=0&sort=price+asc&start=0&filter=(category:"12897")&filter=(a_brand_t_fq:"LifeWerks")&filter=(a_lens_t_fq:"Frosted%20carbonate")'),
        ('https://www.abc123.com/search?facet.multiselect=true&page=1&q=*&rows=15&son=0&sort=price+asc&start=0&filter=(category:"12897")&filter=(a_brand_t_fq:"GEICO")&filter=(a_dimmable_t_fq:"No")'),

I'm not sure why you are adding Eirikur's script as the WHERE clause, because it's a SELECT as opposed to any kind of filter.   I corrected the sample table data...