I had a usecase to remove one of the filed(Secutiry_id) value WHEN IP address is 10.141.20.19.Can you guys help in framing the query

[Manoj1988]

I had a usecase to remove one of the filed(Secutiry_id) value WHEN IP address is 10.141.20.19.Can you guys help in framing the query

[woodcock]

Like this:

... | Security_id = nullif(Security_id, "10.141.20.19")