Q&A BY TAG 'instr function'

You must sign in to ask a question. If you do not have an account, you can register here

How to use 3 parameters in 'instr' function
answered 21-04-2021 20:59:08 -0400

SELECT * FROM <view_name> where instr(<column_name>,'|', 2); Like from which position we need to search the given character.

Answers: 3

instr function

Substring Error
answered 29-01-2020 06:14:57 -0500

version is a column in a table called bv_table values for version looks like Dec[10+2], Jan[1+11]. I am trying to extract the number 10, 1 from the string, any number before +, I am running the below query in the vql shell select SUBSTRING(version, ...

Answers: 1

instr function substring

Need to find Pipe character in a column value
answered 26-09-2017 01:11:55 -0400

I need to find the Pipe character ( | ) in the column value of a field in a view.This is the SQL I am using for my query, however I am not having luck in the reults: SELECT * FROM "My_View" where instr(my_column,'|') <> 0 Please let me know the ...

Answers: 1

VQL instr function