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.
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.