Subject | Sets in like operator |
---|---|
Author | marc_guillot |
Post date | 2007-01-23T17:03:14Z |
¿ There is any way to use character sets with like operators ?.
Something like : (costumers starting whth a, b, c, d or f)
select * from costumer where name like '[a-f]%'
I can't find it in Beta Documentation of Interbase 6, ¿ what's such
sintaxis ?.
(I know I can build a query with some clauses separated with or, but I
will prefer to not have to generate dinamic querys).
Thank you in advance and sorry for my deficient english.
Something like : (costumers starting whth a, b, c, d or f)
select * from costumer where name like '[a-f]%'
I can't find it in Beta Documentation of Interbase 6, ¿ what's such
sintaxis ?.
(I know I can build a query with some clauses separated with or, but I
will prefer to not have to generate dinamic querys).
Thank you in advance and sorry for my deficient english.