I found a better solution in SqlServer 2008

declare @mytable table

(

id int,

potype varchar(10)

)

declare @Text varchar(max)=''

insert into @mytable values (1,'AA')

insert into @mytable values (1,'BB')

insert into @mytable values (1,'CC')

select @Text...

I found this code in Internet some time ago.

I modify to Sqlserver

create FUNCTION IsValidEmail

(@Email varchar(100))

RETURNS bit

AS

BEGIN

Declare @Long Int,

@Pos Int,

@Bueno Bit,

@Ext varchar(1000),

@Letras varchar(100),

@I Int

Set...

I created the next SP

Notes: All coments are in Spanish. I hope you can understand.

You need to register Crystal's Activex.

SET QUOTED_IDENTIFIER OFF

GO

SET ANSI_NULLS OFF

GO

/*

Fecha: 17-Ene-2003

Creado por Carlos Fidel Restrepo

Se utiliza...