Replace Query Syntax

[Former Member]

Hi Guys,

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.

Best Regards

[former_member204969]

Try this one:

SELECT case when $[OSRI.U_Cont_No]='EMPTY' then NULL else $[OPOR.U_Cont_No]  end

[former_member187989]

hi,

Try this

Select CASE WHEN ($[$OSRI.U_Cont_No] IS NULL OR $[$OSRI.U_Cont_No] = ' ') THEN ' ' END

Jeyakanthan

[Former Member]

Thanks man, it worked.

Best Regards