Select Junk Charaters

suzeet · New User Joined: 16 May 2005 Posts: 54

Can I query a table to select is there any junk characters present in that or not?

enrico-sorichetti · Posted: Tue Dec 11, 2007 1:45 pm

please clarify the meaning of "JUNK" :-)

suzeet · New User Joined: 16 May 2005 Posts: 54

My query result should not contain any character except

0,1,2,3,4,5,6,7,8,9 or "."

stodolas · Posted: Tue Dec 11, 2007 6:36 pm

Are you storing numeric data in a Text field in a database? That is just horrible design.

But you are contradicting yourself. First you ask if you can select junk characters then you say your result should only include
0,1,2,3,4,5,6,7,8,9 or ".". Are those what you are considering junk or are those the only valid characters?

Craq Giegerich · Posted: Tue Dec 11, 2007 6:51 pm

What are formats of the columns?

suzeet · New User Joined: 16 May 2005 Posts: 54

Hi

Yrs...the following are the valid characters

0,1,2,3,4,5,6,7,8,9 or "."

mkk157 · Active User Joined: 17 May 2006 Posts: 310

I believe, u r handling some numeric number in CHAR field and in that some junk characters are coming un-expectedly, U want to remove them.

If this is the case, then

with the following wuery u can list out all the fields which contains the junk characters.

SELECT * FROM <TABLE-NAME>
WHERE <FIELD-NAME> BETWEEN '000000' AND '999999'
OR <FIELD-NAME> = '.'

enrico-sorichetti · Posted: Wed Dec 12, 2007 5:09 pm

dbzTHEdinosauer · Posted: Wed Dec 12, 2007 5:37 pm

tables do not have fields. I realize that rookies talk like that, but if you are providing 'professional' help, clean up your rap.