Doing a substr in a select command 1

[meridian99]

Hello Oracle Vets, I was wondering if there a method for the select that would return records that do not have a value in a field of 'HST-'. Otherwords show me all courses that do not have 'HST-' in the course name. In vb you can do a substring to check for the values but not sure if oracle 8i sql has the same/similar function?

thanks for yout help...

 

[SantaMufasa]

Meridian,

Oracle's "quick-and-clean" method to check for "HST-" in the course name is:

SELECT...FROM...
WHERE <expression> NOT LIKE '%HST-%';

Let us know if this satisfies your need.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]