select
iif('em...@testdomain.com' 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.
On 25/11/2014 13:29, sirhamac...@gmail.com [firebird-support] wrote:
select
iif('em...@testdomain.com' 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
Technically speaking, there are things out there like
http://www.ex-parrot.com/pdw/Mail-RFC822-Address.html (just to show, that
very very few people do an actually 100% correct email validation)
2014-11-25 15:39 GMT+02:00 Tim Ward t...@telensa.com [firebird-support] <
firebird-support@yahoogroups.
>select
>iif('em...@testdomain.com' 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.
I know nothing about regular expre
Hello
I use the following SELECT when want to validate an e-mail address and
works fine for me:
SELECT
IIF('em...@testdomain.com' SIMILAR TO
'[[:ALNUM:]-*_*.*]*@[[:ALNUM:]-*_*.*]*.[[:ALNUM:]-*_*.*]*', 'ok', 'fail')
FROM
RDB$DATABASE
Of course, that is not perfect, but works.
Greetings.
W
Yet more simple:
SELECT
IIF('em...@testdomain.com' SIMILAR TO '[[:ALNUM:]-_.]*@[[:ALNUM:]-_.]*',
'ok', 'fail')
FROM
RDB$DATABASE
Greetings.
Walter.
On Tue, Nov 25, 2014 at 10:48 AM, Walter R. Ojeda Valiente <
sistemas2000profesio...@gmail.com> wrote:
> Hello
>
> I use the following SELE