![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 2 of 2 total |
![]() |
Thu, Dec 21 2006 12:44 AM | Permanent Link |
Praveen A B | 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. |
Thu, Dec 21 2006 3:15 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
This web page was last updated on Monday, July 7, 2025 at 06:35 PM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |