Perfect

Thanks

Because I'm old and it still works, I use vb6 to create excel (from SQL stored procedures) and format within the vb code.

I've been sending various reports to people in...

Are the 17k of email addresses in a table?

use master

declare @Foo as table(a int)

insert into @Foo

select 960

union

select 510

union

select 945

Here is code that I got from this site a few days ago.

select convert(varchar, floor((convert(numeric(9,0),...

Thanks Lynn.

I will give this solution to the SQL developer working on this project and let him see if it will work for him.

Tim Hansen

I'm old school.

I do this for clients and use vb6 to not only populate excel spreadsheets, but I also can apply any number format requests and then email the file...

If it were me, I'd modify your table to add the column that you need.

I would then modify all of your triggers to include the information you want to populate...

How about a simple update query add the end of the batch that updates the columns to NULL where value = ''?

I've done this before using LIKE and '%'

exec mySP @FirstName, @Lastname, @status

within the stored procedure

set @Firstname = @Firstname + '%'

set @LastName = @LastName + '%'

set @status...

How about creating a LINKED table in the Access database with permissions set for the end user? Then the data is up to date always.