0

INSTR function in MV SQL

I am trying to use substr & instr in MV SQL. 

 select substr(account, 1, 4) AS ent
,substr(account, instr(account, '-', 1, 1) + 1, 4) AS llc from table

But when I tried to use instr it throws some error. 

 

Does someone knows reason why?

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 3 mths agoLast active
  • 1Replies
  • 13Views
  • 2 Following