Latest Activity


How to use 3 parameters in 'instr' function

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

instr function


Substring Error

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, ...

instr function substring


Need to find Pipe character in a column value

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 ...

VQL instr function