Data type is string and it is a sql express database. Also, i cannot update the etries that already have a '000' prefix so i can do something like :

UPDATE TableName
SET AccountNumber = '000' + AccountNumber
WHERE AccountNumber NOT LIKE '000%'

Correct?

Hi There, I don't really use sql so this can be an stupid questoin but, say ive got a column called accountNumber with the following values: 55123 55124 55124 ...etc and i want to change all the values (5000+ entries) to a concatenation of '000' + the current accountNumber. i.e. 00055123;00055124;00055125 how will i achieve this? Regards and thanks

Hi there, I want to start a process on a remote machine and as soon as the process is complete i want to start a local process. Keep in mind that: - I only have the UNC of the remote pc - The process that must be run is stored on the remote pc and must be run on that pc. - I do not want to map network drives (although it's highly unlikely that i should) This is how I would do it if the first process was run on my local machine.

myProcess.Start();
myProcess.WaitForExit()
//next process

Thank you,

Hi there, If i assign a value to a string, is it possible to go and see where it is stored in the memory and what the value is? e.g.

string _testString = "Value I want to read from memory";

Any way to do this?