Hi
I have job which i need to find values for a column like '%range%'
how do i get all the values like '%range%'
Thanks alot for your time.
Sql Like Clause in DataStage EE
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 38
- Joined: Thu Jul 26, 2007 6:11 am
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
A simple search would have given you many posts which discuss about this......
you can use Index, Count or Dcount to implement this..
you can use Index, Count or Dcount to implement this..
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 38
- Joined: Thu Jul 26, 2007 6:11 am
how do i use the dcount or count or index to
Hi
this is the values i need like '%range%'
how do i use the count or dcount or index to look for the above values.
Thanks for your reply.
this is the values i need like '%range%'
how do i use the count or dcount or index to look for the above values.
Thanks for your reply.
-RK