|
View previous topic :: View next topic
|
| Author |
Message |
Jeevankumar.Pochammala
New User
Joined: 04 May 2011
Posts: 7
Location: INDIA
|
|
|
|
Hello All,
Can any one please let me know the query which can give all junk values from all columns of the table. |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
| Define "JUNK" values |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
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. |
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8697
Location: Dubuque, Iowa, USA
|
|
|
|
| Quote: |
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. |
|
| Back to top |
|
|
|
|
