November 14th, 2003, 11:45 AM
Does Firebird support Wildcards and if yes, how?
The ANSI-Wildcard-Symbol (%) is NOT Supported! :-(
November 14th, 2003, 06:24 PM
select * from person
where name like 'A%';
works for me.
Be aware that firebird is case sensitiv! like 'a%' is something different then like 'A%'
November 15th, 2003, 07:55 AM
i've tried something like
SELECT * FROM Person WHERE name LIKE 'a%'
but i don't knew that firebird ist case sensitive. Thanks a lot. Maybe that's the Problem!