Forum Stats

  • 3,734,347 Users
  • 2,246,954 Discussions
  • 7,857,241 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.