<bert_herngreen@...> wrote:

>
> Hi,
>
> It's probably because it's friday afternoon, but I don't see what I'm doing wrong.
>
> I want to check if a field/value contains a certain value devided by a dot (´.´). How do I have to threat the dot, do I have to escape it?
>
> -- Returns null:
> select 1 from rdb$database where ('3.4' similar to '[:DIGIT:]+.[:DIGIT:]+')
>
> -- Returns error, 'Invalid ESCAPE sequence':
> select 1 from rdb$database where '3.4' similar to '[:DIGIT:]+\.[:DIGIT:]+' ESCAPE '\'

Use [[:DIGIT:]] and read documentation more carefully ;)

Vlad