General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I want to create query that reads a variable from the first
underscore to the second.
Maybe
M_ABC_123 = ABC
M_QWERTY_321 = QWERTY
I have writen this query
SELECT SUBSTR(partno,ATC("-",partno,1)+1,ATC("-",partno,2)-ATC("-",partno,1)-1) from plan
Its returns
ABC
QWE
What is the problem.
Thanks.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only