Forum Stats

  • 3,728,688 Users
  • 2,245,675 Discussions
  • 7,853,705 Comments

Discussions

Substring and Locate

Hi

It is in OBIEE 12

I am using the substring and locate functions to find a specific word in a text field and it is fine but when that word I am looking for does not exist in the text, it is capturing the first word in the text...how can I have it so when that word I am looking for is not in the text then return blank?

Thanks

Joe

Answers

Sign In or Register to comment.