Not worthless... this is what we call experience .

The name says it. It's computed (calculated) on the fly when you request it in a select. It's usefull when you have complexe calculations that you want to...

Still takes 12 queries to populate the dataset (at least one per col) + 1 to call that one, not to mention the inserts in the table...

Well you'd use some dll in sql server to do that... which would be written in vb. So I think the simplest way would be to handle that all...

Because if you use where replace (col..) = @SomeVar, you'll get an index scan all the time. however if you use the computed column (which updates itself BTW), amd...

Seems to me like you're already able to do all the stuff programatically at some point in the program. What forbids you to send the jpegs over ftp, or...

Doh...

try it like this :

LEFT(REPLACE(Colname, ' ', ''), (length of the original column)

EPNOM is the name of the other column you need to replace the spaces from.

What do you need to do exactly to transer the info (from where to where)?

dbo.Temps is the table name

demo is the name of the new column.

This is the job of an application... not the server's job.. check out .net help. It's supposed to be easy to do .

Why do you want to do that?

ALTER TABLE dbo.Temps ADD

 demo  AS replace(EPNOM, ' ', '')

GO

CREATE NONCLUSTERED INDEX IX_Temps_Demo ON dbo.Temps (demo)

Well sooner done than said... You were still a little late on this one .

Create an indexed calculated column that strips out the spaces. Then do the search on the column (making sure that the search parameter doesn't have spaces too).