|
View previous topic :: View next topic
|
| Author |
Message |
srajendran2
New User
Joined: 13 May 2008
Posts: 56
Location: Chennai
|
|
|
|
I have a column defined as character which is used to store address. The address field present in the table has Address + low values. Please find an example below
121 2600 ROAD ........
I would like to find rows which have data like the one mentioned above. Is there any possibility of finding it using a query? Please let me know your thoughts |
|
| Back to top |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
you could address the last position in your CHAR column with SUBSTRING.
search the db2 forum for examples. it has been a few months since anyone asked this type of question. |
|
| Back to top |
|
|
Succor
New User
Joined: 20 Feb 2009
Posts: 96
Location: Bangalore :)
|
|
|
|
Try LIKE predicate.
WTH |
|
| Back to top |
|
|
|
|
