Forum Stats

  • 3,735,181 Users
  • 2,247,134 Discussions
  • 7,857,764 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.