|
View previous topic :: View next topic
|
| Author |
Message |
kanisha_prabha
New User
Joined: 10 Mar 2006
Posts: 26
|
|
|
|
I need to do a partial search on a particular descriptor field in ADABAS. In DB2 I could use something like hte following -
SELECT ...
FROM ...
WHERE EMP_NAME LIKE 'KANISHA%'
...
Is there any way I can represent the LIKE parameter in ADABAS? |
|
| Back to top |
|
 |
Gnanas N
Active Member
Joined: 06 Sep 2007
Posts: 792
Location: Chennai, India
|
|
|
|
| Same query will work in ADABAS also if it's in ANSI SQL standard... |
|
| Back to top |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005
Posts: 2358
Location: Israel
|
|
|
|
You can use the STARTING FROM operand of the READ statement.
O. |
|
| Back to top |
|
|
|
|
