Hi All.

Using DBISAM 3.17.
I have a column Table_Name which consists of table names having underscore "_" Ex. POS_MASTER, TAB_KEYS, POSITION_DETAIL etc.
I want to write a SQL SELECT/UPDATE statement to search for Table_Name with value starting with "POS_" and not "POSITION_".
I have tried using the LIKE operator -
select * from table where table_name like "POS_%" but it returns POS_MASTER and POSITION_DETAIL. I need only POS_MASTER.

Can any tell me how ? I think v3.x doesn't support ESCAPE clause.

Praveen.

Praveen,

<< Can any tell me how ? I think v3.x doesn't support ESCAPE clause. >>

You are correct.  4.x introduced support for the ESCAPE clause.  The only
way to do it is to loop through the records manually in the table doing the
comparison.

--
Tim Young
Elevate Software
www.elevatesoft.com