Yet more simple:
SELECT
IIF('[email protected]' SIMILAR TO '[[:ALNUM:]-_.]*@[[:ALNUM:]-_.]*',
'ok', 'fail')
FROM
RDB$DATABASE
Greetings.
Walter.
On Tue, Nov 25, 2014 at 10:48 AM, Walter R. Ojeda Valiente <
[email protected]> wrote:
> Hello
>
> I use the following SELECT when want to validate an e-mail address and
> works fine for me:
>
> SELECT
> IIF('[email protected]' SIMILAR TO
> '[[:ALNUM:]-*_*.*]*@[[:ALNUM:]-*_*.*]*.[[:ALNUM:]-*_*.*]*', 'ok', 'fail')
> FROM
> RDB$DATABASE
>
> Of course, that is not perfect, but works.
>
> Greetings.
>
> Walter.
>
>
> On Tue, Nov 25, 2014 at 9:29 AM, [email protected] [firebird-support]
> <[email protected]> wrote:
>
>>
>>
>> select
>>
>> iif('[email protected]' similar to
>> '([_a-zA-Z\d\-\.]+@[_a-zA-Z\d\-]+(\.[_a-zA-Z\d\-]+)+)','ok','fail')
>>
>> from rdb$database
>>
>>
>> Says 'invalid string' and 'invalid pattern', but the pattern it´s the
>> same in other languages for validate email address.
>>
>>
>>
>>
>
>
