Search results
-
R
How do I extract first characters of a string with delimiters
How do I extract first characters of a string with delimeters. For example I tried this statement: Select "order-no" as "COL1", substr("order-no", 1, instr("order-no", '-',1, 2) ) as "COL2" from PUB."table" where "order-no" like '4250%' and got the following result: COL1...- ritchierich
- Thread
- Replies: 0
- Forum: SQL-92