in a saved search, is there a function I can use similar to

DECODE

but where it returns the original value as the default?

Case when no?

CASE WHEN {expr} != 'Key' THEN {expr} END

not any way that I can think of are you having to calculate

{expr}

, which is computationally expensive or complicated?

@David B yeah but it's just a simple CASE WHEN, not a huge deal just was hoping not to have to repeat it. I wound up sticking with DECODE anyway

I went googling and found past-me asking the same question 😆: https://archive.netsuiteprofessionals.com/t/344611/is-there-a-way-to-declare-variables-inside-of-a-saved-search

Hahaha damn that's how it is sometimes. I've definitely done the same thing