I think that this articole is very academic and it is not useful for work, because it works, it's true, but the indexes? Do the indexes works?

Bye

mandu

Try this script:

declare

@counter smallint

declare

@first varchar(4000)

declare

@notNumber char(1)

while

exists(select Phone

Hi,

i test my user function and i reveived OK:

select dbo.fnTestStringWithRegularExpression('myname@agency.state.statecode.us', 1, 'T', 'T')

tell T, so the email address is ok.

Bye

Hi,

you can use the regular expression with a user function like this:

--select dbo.fnTestStringWithRegularExpression('pippo123', 4, 'T', 'T')

ALTER         function [dbo].[fnTestStringWithRegularExpression]

 (

  @stringaDaControllare varchar(4096),      -- stringa da controllare

  @tipoStringa smallint,                  -- 1 = email

                                    -- 2 =...

Hi,

i have a similar problem and i have solve it with a user function like this:

--select dbo.fnScontoStringaInNumero('3,5+3+0', '+')

-- per motivi di performance il programmatore...