Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
Every byte in a table may contain a value from x'00' thru x'FF'. NONE of these are junk. Some may not be what you expect/want, but they are not junk.
If you post a more descriptive explanation of what you want to accomplish, someone may have a suggestion. Show a sample table definition including good and bad data and what you want your query to accomplish when it runs.
Joined: 06 Jun 2008 Posts: 8214 Location: Dubuque, Iowa, USA
the query which can give all junk values from all columns of the table.
This is a VERY poorly worded and thought-out post. For example, one column of the table is phone number. A "junk value" for this column could be "John Smith". Yet, the very next column of the table is emergency contact, for which "John Smith" is perfectly valid yet "(404) 555-1234" would be a "junk value".
One column's "junk value" is another column's valuable data.