Thanks a lot to both! You are great!

Mi table have less of 3000 rows, your query is efficient.

Thanks by your help! You has safe me!

Thanks! I going to looking for more information about IDTC and will change the comparisons where are different the type of data (unicode/nonunicode).

You has give a light!

Thanks a lot David! Your solution is correct!

Data to delete or change: JR ISMAEL ¹GADOR 298

Data to output: JR ISMAEL GADOR 298

User Function:

CREATE FUNCTION [dbo].[REMUEVE_SIMBOLOS_SE_FN](@str varchar(max))

RETURNS varchar(max)

AS

BEGIN

DECLARE @i int

DECLARE @r varchar(max)

...

My problem was resolved.

Thanks by your help!

Thanks! I dont have the error!

Thanks I has solution the error creating other table with group by.

Thanks diamondgm! The solution was:

select sum(len(ltrim(rtrim(replace(Column1,' ',''))))+len(ltrim(rtrim(replace(Column1,' ',''))))

from table

Thanks to everybody.

The solution was that I change the target of file with the UNC of mapped unit.

The account of service SQL Server Agent and service SQL Server are running with my account network that have acces and all permissions of access(read, write, execute). I have to...

Everybody talk me about a script, can you tell me some tips or steps of how I can do it this?

Thanks by your help

Dear Lowell you have reason, I has talk with network admin and any server that there isn't suscribed in the list of SMTP will not permit out emails.

Thanks for your...

Dear Lowell, I has configured de Database Mail like the picture of your answer, but when I Send Test-Email show the follow error:

The mail could not be sent to the...

I dont have a SMTP for use.

I has configured the SQL Mail with the follows parameters:

- E-mail address: myaccount@gmail.com

- Server name: smtp.gmail.com

- SMTP Authentication:

...