6 Oct
1999
6 Oct
'99
8:34 p.m.
Hi again, I have a question regarding the ZSQL methods. How do you use LIKE in your sql statements? ex: SELECT * FROM clients WHERE last_name LIKE <dtml-sqlvar search_criteria type=string>% the problem arises because the type automatically adds the '' around the search_criteria and the percentage sign needs to be inside the '' as in 'Smi%' for all accounts that start with Smi. Thanks in advance. -- Mats Nordgren First Union Securities mats@launchnet.com icq: 14659299