Forum Stats

  • 3,686,721 Users
  • 61,101 Discussions
  • 206,400 Comments

Discussions

Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now!
RUN, DON’T WALK...Registration for #SuiteWorld 2022 is officially OPEN! This special early bird price won’t last long, so make sure you don’t miss out: https://lnkd.in/gGRN78A3
Virtual Event: Getting the Most Out of NetSuite Standard Costing Capabilities

You asked for it, you got it! Join the webinar Getting the Most out of NetSuite Standard Costing Capabilities on June 28, 2022 at 11AM PT. Register here!

WATCH: Search Formulas SQL Expressions CASE syntax

This video contains a solution on how to create a Saved Search that will include results depending on a CASE clause SQL expression formula.

Here is the formula used in the video presentation:

  • CASE WHEN ({isperson} = ‘T’) THEN ‘Individual’ ELSE ‘Company’ END

Kindly mark "Yes" if you find the reply to your question as helpful. This will aid the community to find the solution/answer much easier. Let's always mark a reply and help the community! ☺️

Shamaine Chan-Oracle | Ask a Guru

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!

Leaderboard

This Week's Leaders

This Month's Leaders

All Time Leaders