Replace Query Syntax
I'm trying to do a a formatted search with a query that will look up the value of a field(the field that will have the formatted search), and replace it with nothing(the field becomes blank) if it is a particular value.The syntax I'm using is:
Select WHEN $[OSRI.U_Cont_No] = 'EMPTY' THEN NULL
Can anybody help me with the correct sytax for this query?
Thanks in advance for your help.