View previous topic :: View next topic
|
Author |
Message |
Anand78
New User
Joined: 06 Mar 2006 Posts: 50 Location: PUNE
|
|
|
|
Hi ,
In DB2 table , one column is defined with CHAR(05).
First three bytes is having high values and last two bytes is having spaces.
I want to retrieve rows only having high values in the first three bytes.
Please suggest.
Thanks
Anand |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
Quote: |
I want to join this forum for better understding of basic concepts and to give quality of work to clients
|
suggest:
I wanted to join this forum for a better understanding of basic concepts in order to provide quality work to my clients.
AND SUBSTR(columnname,1,3) = X'FFFFFF' |
|
Back to top |
|
|
|