thanks for creating a bug, today i have noticed one more issue. Some of the forum questions and articles that are in my briefcase(under profile) doesn't display them. if i...

create table...

thanks, i do have a scenario where there will be combination 'or', 'and'. 
if it is only and clause i can split data easily.

i have a filter to remove any values that are blank in my original post. i have added code that i was able to achieve results by adding sort...

thanks thom, i dont want to store null values in the table,  may be if i introduce a sort order field it might help, but i was not able to...

thanks for your help , i dont want to display setting and value i have removed that from final string . it looks good.

set @table_results = REPLACE (@table_results...

hey thanks for your reply, my issue i need to display as pivot . Header should be on column 1 and column2 will have corresponding values.

I have wrote a function which checks sql injection this is sample code to demonstrate issue i

have

Yes I am trying to replace it for all the underscore occurrences in the filter statement.

Challenge is I should replace underscore for like operator not for equal to...

As jeff said make sure you have post DDL in consumable format next time. below is the code let me know.

IF OBJECT_ID('tempdb..#temp') IS NOT NULL

DROP TABLE #temp

GO

CREATE TABLE #temp...

this is a legacy system not in use currently, we are trying to find true credit card numbers so that we can mask with xxxx characters.

other thing application used...

thanks alan for your time and providing a solution i will test it on my data and make necessary changes if needed based on my real data