>I have also tried to put this string into a text file and then assign it to a variable with SET PATH TO cPath and it
>returns no error.When it comes to the first table or program it cannot find the location.Is there any other way that I
>can try.
I think You must evaluate the string in SET PATH i.e. SET PATH TO (cPath)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.