View previous topic :: View next topic
|
Author |
Message |
Munish Singla
New User
Joined: 18 Jul 2007 Posts: 21 Location: kolkata
|
|
|
|
I have an address column in a table which is of varchar() type so that it can contain alphanumeric data.
I need to fetch a row which contains only numeric data. |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
Munish Singla wrote: |
Hi All,
I need a urgent help.
I have a address column in a table which is of varchar() type so that it can contain alphanumeric data.
I need to fetch a row which contains only numeric data.
Could you please help me out? |
What format is the numeric data in, packed, binary, or character? |
|
Back to top |
|
|
Munish Singla
New User
Joined: 18 Jul 2007 Posts: 21 Location: kolkata
|
|
|
|
It is a number like 123456.......
it resides in a column which is varchar() type.
Now number can start with any digit.
Also i have to fetch the row that contains only number no character or specail character. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Sounds like this is not really an address. If it is not, it should not be stored in an "address" column, but rather in some other properly defined column(s).
What should happen if the data is "12 34 56"? Is there a maximum or minimum "valid" length? Does the query need to traverse the entire table or is there some additonal selection criteria? |
|
Back to top |
|
|
|