| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
| substr(number,3,2) IN ('03','18','09','07') i need to fetch |
« View previous topic :: View next topic » |
| Author |
Message
|
| satheesh kampati |
 Posted: Sat Mar 23, 2013 10:53 am Post subject: substr(number,3,2) IN ('03','18','09','07') i need to fetch |
 |
|
Newbie
Joined: 28 Dec 2012
Posts: 5
|
Hi all,
I am trying to get these records which are having these values
EG: substr(10035489,3,2) IN ('03','18','09','07') )
Then i should get 03 else the other values which are having 18,09,07 |
|
| Back to top |
|
 |
| adubya |
| Posted: Sat Mar 23, 2013 12:13 pm Post subject: |
|
|
Partisan
Joined: 25 Aug 2011
Posts: 377
Location: GU12, UK
|
| This is a simple requirement which I would expect a competent broker developer to satisfy easily. If you're struggling then please read the infocenter content regarding string functions. |
|
| Back to top |
|
|
|
|
|
  |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
