Forum Replies Created

Viewing post 1 (of 1 total)

  • Reply To: replacement of InStr function in SQL

    would anyone on this post know how to replace instra in this

    select substr(caption,(instr(caption,'@') + 1 ), length(caption)), (instr(caption,'@') + 1)

    FROM "CONVIVA_ANALYTICS"."INSTAGRAM_POST_METRICS"

    WHERE postid = '1971324349038518078_1547775030'

    ORDER BY caption;

    I am trying to grab...

Viewing post 1 (of 1 total)