Comments by Member 12678237 (Top 1 by date)

RossMW,

I am going to try and explain it a little better. This is for a website, and basically the current "AND i.here IN ('Y', @activeInd)" is what I am wanting to replace with something like the below AND StatusOf IN ('Y', @activeInd)"

I want to be able to use the StatusOf which is not a field in the database, so I can search active and inactive items. The only database we had I had a field for StatusOf so I could search easily with Y/N vs this software vendor I no longer have that option, so I am hoping I can use the case above somehow, that is the part I am not sure how to do if that makes better sense?