Hello,

I have data in a table and I need to exclude data if it meets a certain criteria. This need to produce a new table listing and be provided to a application. First, I need to:

SELECT * FROM ACTIVITY
WHERE
ACTIVITY_NM LIKE '%UNKNOWN'

And

please be more vague to make answering more challenging.

We do not know what you start with.
We do not know what the actual results should be.
Other than that your problem statement is as clear as mud.

That's the difference from a DBA and a Developer, Left coast and Right coast. I think not like solves the issue for me. My problem is this is a application driven by developers. Not the database. So, the data is all #$%%$*&*(T(*&^)$. No referencial intergrity. Were if it was database driven. I would not need to clean up data to produce back to a application that will continue to have bad data in the database tables.

Just a thought.

Sorry, need to attend the SAN

P.S.
Please if you know of anyone in this industry coast to coast and world wide. Please have them to look at this sites "job opportunites" and appy.

Thanks
G

THANKS for the clarification.

NOT!

With all your post. You got to be a vet with alot of experience. So when thing like this come up. Who has time to remember the coding you did 20 years ago. Hell, That's how I got my start in the industry. Oh, yeah, we did have things like this this. You remember verion 5.0 of Oracle. THERE was no internet, Forum. hell. Email had just come along. The good old days.

When technology move faster than a Bug and Elmer fud.

One of the first rules I learnt when I started in IT was never to touch a keyboard if I'd been drinking...

If you try to fix (manipulate) the data in order to produce "acceptable" results, your customers (and developers) will get use to it and expect you to "fix" everytime the c.r.a.p. they enter (or allow to enter) the database.

If you cannot have the developers fix their own data, RUN as fast as you can.
Eventually they will blame YOU for the bad data.