what Antares meant to say is :

Update MyTable set MyColumn = replace (MyColumn, 'x', '')

where charindex ('x', MyColumn) > 0

that way only the columns that actually need modifying would...

Too many good solutions to this questions... just as long as you keep the conversions down it's gonna be fine... I've seen 2-3 solutions here that do it in only...

I don't think it would make that much of a difference.

Unless sql server is on another machine than the web server, then you could see where it is best to...

Just out of curiosity.. how long does it take now to perform the same operation compared to the old code?

maybe you could modify my¸(or your) script so that it runs at least 4 times a day (making 4 different copies)...

glad it worked 🙂

For starters :

if you have a recent backup of the ADP you can copy the working form from the backup under a new name, then update any modification mades...

if you can see it you can save it :-).

However maybe you mean the file is not formated in a way that can be transfered into the database... because if...

Just ou of curiosity, why not make a new column for the (empty) string instead of concatenating it to the fund part?? seems to be more of a presentation...

Select right('00000' + cast(MyFieldName as varchar(5)), 5) as MyFieldName from MyTable

Hey Yoda I'd be interested in hearing your thaught process on how to pick your PKS and when you use identity (as absolutely necessary) and when to avoid it at...

Ctrl-0 works only in enterprise manager to set a value to null.

Are you using access or vb to display the information?

in access you can simply set the value to null...

Here's what I usually do...

if I know I'm gonna use the NN table in another relation (can't think on one in this situation at the moment), then I use an...

this is csharp but it can give you a start

http://www.eggheadcafe.com/index/System.Windows.Forms_ConvertEventArgs_390d2fc4-8bd2-452e-b9fd-695da56a6680.asp

but this ones seems to do the job (it's for a image but I guess the process is pretty much the...

How about storing the file on a shared network drive and simply saving the path on sql server (much less overhead on the server).

I'm not sure I'm following you here.

from VB

SomeField.value = null

from SQL

Update MyTable Set MyField = null where MyField = @MyDate

or

Update MyTable Set MyField = nullif(@MyDate, MyField)