After Hours

Ask something
Question Locked

SQL String manipulation

0 helpful
2 replies

by cathy.berry

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'm working with an Oracle database and have a text field of identifiers. The data I'm trying to extract is in different positions. For example:

Today = 01/11/08 and the day = Friday and it is raining
The date = 01/10/08 and the day = Thursday and we need the rain
The day after tomorrow = 01/12/08 and the day will be Monday and rain is coming

I am using INSTR to locate the beginning position for Friday, Thursday, and Monday but how do you figure out how many positions before the next ' '?

Is there something other than INSTR or can INSTR be used?

Thank you!

2 replies

by robo_dev

SELECT * FROM your_homework WHERE CONTAINS (your_field_name, '"Monday*" OR "Tuesday*"')

or the lazy approach

WHERE your_field_name LIKE '"%day%" '

or

WHERE CONTAINS (your_field_name, '"day*" ')

This discussion is closed to new replies.